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
Subject: [PHP] Re: mysql query

function mysql_one_element($query, $element) {
  // quickly returns just one element from a query
  // add error checking here if you wish

$row=mysql_one_element("select euro from brandstofprijzen where id=2",

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

Reply via email to