Displaying mysql_result

[cdoggg94]

<?php
$link = mysql_connect('localhost', 'user', 'pw');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
if (!mysql_select_db('my_DB')) {
    die('Could not select database: ' . mysql_error());
}

$query = mysql_query("SELECT SUM(wish_total) FROM wish_list WHERE  wish_product= '30108'");
if (!$query) {
    die('Could not query:' . mysql_error());
}
echo mysql_result($query);
?>

 

in the code above i am trying to add up the wish_total column in my table wish_list.  When i ran this query in phpmyadmin, it added it up fine.

 

Im not sure if i am echoing the correct thing, because i think that the query is working.

 

suggestions ?

[Jessica]

Do you get an error from mysql error? What output do you get?

You will want to assign that SUM a name btw.

SELECT SUM(wish_total) AS summed_wish_total FROM wish_list WHERE  wish_product= '30108'

[ialsoagree]

I don't normally use mysql_result, but I think the row parameter is not optional:

 

echo mysql_result($query,0);

[cdoggg94]

I do not get an error...

 

Basically it it left blank.

 

I will try the to assign it as you have stated and get back to you.

 

Sorry i was away for an hour.

 

I will respond very soon!

[cdoggg94]

I think with the additions you 2 have made to my script it is working the way it should be !

 

Many thanks !

 

I appreciate it very much !