Easiest way of converting an id to name

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
mikeman
Forum Newbie
Posts: 18
Joined: Wed Apr 07, 2010 7:18 am

Easiest way of converting an id to name

Post by mikeman »

If you have a table containing many different ids that each have their names stored on another table is there an easy way of converting that id to a name.

Or would you have to have lots of SQL statements fetching the name for that id on each table?
User avatar
AbraCadaver
DevNet Master
Posts: 2572
Joined: Mon Feb 24, 2003 10:12 am
Location: The Republic of Texas
Contact:

Re: Easiest way of converting an id to name

Post by AbraCadaver »

It's not lots of SQL, just this if I understand correctly and assuming that the tables are related on the id column:
[text]
SELECT name FROM ids_table, names_table WHERE ids_table.id = names_table.id[/text]
mysql_function(): WARNING: This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQLextension should be used. See also MySQL: choosing an API guide and related FAQ for more information.
Post Reply