Change a mysql query result prior to display

view full story

http://www.linuxquestions.org – I am not sure if this is possible. I have IP's stored in a mysql database. When I query the database, it returns the IP. I would like to replace the IP with something else prior to displaying the results. Is it possible even though I have not stored it in the database? I have the following in a while loop (mysql_fetch_array). Code: <td align="left">' . $row[IP] . '</td> Instead of displaying $row[IP] from the database, I would like it to display something else which I define in the PHP code but based on the IP. ie. aaa.bbb.ccc.ddd = hostnameABC Thanks & Regar (HowTos)