How to store last 4 characters of a string.

[bsamson]

Alright I have searched and searched. So here goes ...

 

$number = "123.456.7890"

 

I need to grab "7890".

 

So: $lastfour = "7890"

 

How do I do this? Thanks in advance!

[Ken2k7]

Is the number after the last "." always 4 digits?

 

<?php
$arr = explode(".",$number);
echo $arr[count($arr)-1];
?>

[drummer101]

<?php
substr($string, -4)
?> 

[bsamson]

Thanks. Just one more thing ...

 

Here's the situation:

 

Users enter a page and enter the last 4 of their phone number. I have a DB w/ this info.

 

So for example:

 

Field: Phone

Contents: 123.456.7890

 

If a user enters "7890" I need to create a query that finds the above field. How do I go about doing this? Thanks again in advance!

[GingerRobot]

SELECT * FROM tbl WHERE SUBSTRING(col,-4) = '7890'