I am trying to get data back out out of a database in the following way....
$sql = "SELECT * FROM tablename WHERE id='$id'";
$result = mysql_query($sql);
$something = mysql_result($result,"field-name-i-want");
But for some reason it only ever returns the first field in the table as opposed to the "field-name-i-want"
The "printf" thing works fine, but I want it in a variable!!