Is it possible to retrieve one cell of data from a MySQL database? I need to put the ID from one row of a table into a php variable so that I can recall the correct row later on for editing purposes. If you know how to do this please help me! I will post my code if you ask me to.
i should be a little more specific. i can get to the point where i have the $result array that has the results of that query we were talking about.
// run the query on the connection
if (!($result = @ mysql_query ($query, $connection)))
i don't know what to do with the $result array to retrieve this one piece of data (an ID). The query only asks for one piece of data so the array should only have one item in it. So that's where I'm at