Try mysql_result(); in place of that entire while() loop. http://www.php.net/manual/en/function.mysql-result.php
Also there's no reason for you to use mysql_free_result() unless you're going to be performing multiple massive SELECTS before the script exits. -Kevin ----- Original Message ----- From: "Chris Schoeman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 10, 2002 10:53 AM Subject: [PHP] mysql query > 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 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php