MySQL Query Help

[Drezard]

Hello, what is the shortest code to retrieve variable(s) from a MySQL Database? I have a few variables i need retrieved and each time i do it, it takes up about 8 lines of code...

 

- Cheers, Daniel

 

 

[gerkintrigg]

$r=mysql_fetch_array(mysql_query("SELECT * FROM table WHERE id='1'"));

echo $r['whatever'];