Extracted $row after a query

[neilmurray]

Hi,

I am running the following query

$query = "select sum(offernumber) from offers where offerprice='120'";
result= mysql_query(query);

how do I then extract this result?

Thanks,
Neil.

 

[sleipnir214]

It will involve one of PHP's mysql_fetch_*() family of functions, which include mysql_fetch_array(), mysql_fetch_assoc() and mysql_fetch_object().

Take a look at the example code on the page in the PHP online manual for mysql_fetch_assoc()


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[neilmurray]

Thanks,

Neil.