Look into the LIMIT command, it will limit the number of rows in the result set to the number you specify
-----Original Message----- From: bill [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 7:10 AM To: [EMAIL PROTECTED] Subject: [PHP] Re: mysql query function mysql_one_element($query, $element) { // quickly returns just one element from a query $one=mysql_query($query); // add error checking here if you wish $r=mysql_fetch_array($one); $thisvalue=$r[$element]; return($thisvalue); } $row=mysql_one_element("select euro from brandstofprijzen where id=2", "euro"); Chris Schoeman wrote: > I use the script below to get one value out of a database: > > $result = mysql_query("select euro from brandstofprijzen where id=2") > or die (mysql_error()); > while ($row = mysql_fetch_array($result)) > { > $euro = $row["euro"]; > } > mysql_free_result($result); > > This is working fine, but is there an easier (less code) way to do > this? > > Thankx -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php