Ooops, for clarity, I shouldn't have named the result of the function "row" but
"euro". It should be:
$euro=mysql_one_element("select euro from brandstofprijzen where id=2", "euro");
Bill wrote:
> 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
