echo database value

[scotte]

Whats a simple command to echo databse values on a page.

This is how i thought it would work, however its not printing the information!! Any help much appreciated. It won't be to hard for all the php gurus we have here!

<?php

$query = "SELECT products_price WHERE product_id='1'";
$result = mysql_query($query)
echo ("$result");

?>

[scotte]

Still not working

<?php
$query = "SELECT products_price FROM products WHERE products_id='1'";
$result = mysql_query($query)
	or die ("error");
   echo ("$result");

?>

My result is not what im after!

Resource id #3

Any help please..