I have a form my users fill out that write to a MySQL DB. It also captures their IP and places it in a field called IP.
When I query this information into an html page how can I display the results as ****.****.****.XXXX
I only want the last octect of the address to display on the page, but I want the MySQL to record the actual IP address.
Is there a way I can make this happen?