[SOLVED] what is the best way to display a query result?

[trampolinejoe]

Hello,

 

What is the best way to display the result to this query on a html page.

 

$result = mysql_query("
SELECT COUNT(*)
FROM orders
WHERE product = 'MonkeyBars'
AND status = 'paid'");

 

I want to do something such as

 

We have <?php echo "$monkeyBars" ?> in stock

 

Displays

 

"We have 2 monkey bars in stock"

 

Cheers,

Joe.

[premiso]

<?php
$result = mysql_query("
SELECT COUNT(*)
FROM orders
WHERE product = 'MonkeyBars'
AND status = 'paid'");
$row = mysql_fetch_array($result);
?>

We have <?php echo $row[0]; ?> in stock.

 

Something like that should work.

[trampolinejoe]

Thanks Mate,