Shortest way...

[benbox]

Hi people,

Can anyone help me with ideas solutions for this please?

I'm looking for the shortest way to return a field name, e.g. "name" from a mysql table from an ID

so for example, if I had a table with
ID - Name
1 - Test 1
2 - Test 2
3 - Test 3

how could I quickly get the Test 2 string out given the ID 2

is it possible to do it with 1 line of text? something like this which is short and simple is what im looking for, as it would help!

Thanks very much
Ben

[Natty_Dreadlock]

u cannot do it in one line, however, 5 simple commands will do:

$db = mysql_connect("server.test.com", "username", "password");
mysql_select_db("mydb", $db);
$res = mysql_query("select name from table where id=2", $db);
$data = mysql_fetch_assoc($res);
mysql_close($db);

now, $data["name"] contains the value u r lookin for, u just have to set the db server, pw, user and name. note this lines do not use any error handling, so this should be added when usin this on a production system. pls check the docu for further details.
hth