echoing results of a query

[robsgaming]

How to i turn the results of this query into a variable, then echo out the variable?

SELECT SUM(OrderPrice) as OrderTotal FROM Orders WHERE OrderDate BETWEEN '$year:$month:01' AND '$year:$month:31'

[ltm]

$database_handle = mysql_connect($hostname,$username,$password);

$query = "SELECT SUM(OrderPrice) as OrderTotal FROM Orders WHERE OrderDate BETWEEN ";

$results = mysql_db_query($database_name,$query);

$value = mysql_fetch_object($results);

echo" The Total is : $value->OrderTotal";

This should do it.

[Quevas]

Don't include variables between single quotes, write "'".$variable."'" or \'$variable\' instead.

This script shows results from an sql query:

$result=mysql_query($yourQuery,$yourConnection);
$info=mysql_fetch_row($result);

for($i=0;$i<count($info);$i++)

echo $info[$i];

[robsgaming]

Ok

I run this:

$database_handle = mysql_connect(xxx,xxx);
$query = "SELECT SUM(OrderPrice) as OrderTotal FROM Orders WHERE OrderDate BETWEEN '2002:10:01' AND '2002:10:31'";
$results = mysql_db_query($database_handle,$query);
$value = mysql_fetch_object($results);
echo" The Total is : $value";

and get this:

Warning: Supplied argument is not a valid MySQL result resource in /home/batcom/htdocs/bwdOnly/netorderTotals.php3 on line 35

any ideas?

[tomhath]

Could be a lot of things. Try this:

$query = "SELECT SUM(OrderPrice) as OrderTotal FROM Orders WHERE OrderDate BETWEEN '2002:10:01' AND '2002:10:31'" or die "Query failed: " . mysql_error();

[ltm]

Please make the following changes and try again:

Change this
$results = mysql_db_query($database_handle,$query);

to say
$results = mysql_db_query(Please put the name of your database here,$query);

Also replace this

echo" The Total is : $value";
by
echo" The Total is : $value->OrderTotal";

Thanks