[Reg]

I have data that is stored into mySQL. In a particular field, I have data in it that is a long number. How would I go about displaying say, the last 8 or last 6 digits of that number? Thanks.

[Rapid Dr3am]

Use LIMIT 6.

[Reg]

I'm not sure what you mean.

I'm calling the data from PHP to display to a user. But, I only want to display the last few digits. How would I use LIMIT 6?

[Rapid Dr3am]

PHP Code:

$sql = "SELECT username FROM users
WHERE username <> 'Anonymous' 
ORDER BY ASC LIMIT 6; 

[Reg]

That code doesn't work. That limits my results to just 6. I'm trying to limit the amout of text in the field that is being displayed to 6.

Here's an example:

Table "A" column "A" contains -> 1234567890

I only want to display to the visitor -> 567890

How would I do this?

[RynO]

substr($string, -6, 6);

---------------------------

<?PHP

$string = "1234567890";

$new_string = substr($string, -6, 6);

echo $new_string;

?>

Would display 567890.

[Reg]

That did it. Thanks.