Re: Re: mysql

On Wednesday, April 10, 2002, at 07:45 AM, David Robley wrote:

I've been looking on the net and the php docs for a simple mysql query solution, can someone please let me know the best way to get the values of a query that only returns 1 record? All the select query examples on the net are examples of multiple records being returned, and therefor, there is repition methods shown. For this I don't need any repitition, I just need to know the best way to get the DB values from the query into variables. Cheers. -Mason

A while or similar should still work with only one record; but of course you could just drop the while and use the 'enclosed' code just once. If you have a particular sample you want to reduce, post it if you need more help.

Yes, just last night I discovered that the while or other loop is really only necessary if you're retrieving possible multiple results. You can do it very simply just like $sql = "SELECT..."; $result = mysql_query($sql, $db); $row = mysql_fetch_row($result); echo $row[0]; And of course the above can be modified for multiple columns/array elements. Someone did suggest that you use an if statement, however, in the event that no records are retrieved -- if (!$result = mysql_query($sql, $db)) { echo "No records found."; } else { $row = mysql_fetch_row($result); } Erik ---- Erik Price Web Developer Temp Media Lab, H.H. Brown pricee@hhbrown.com