>When trying to do this query:
>
>$rsum =mysql_query("SELECT SUM(rating) FROM ratings where threadid = $ratevar")or
>die (mysql_error());
>
>This is the output:
>Resource id #15
>or some other seemingly arbitrary Resource ID number?
>First of all what is a resource ID and second how do I get it to actually
>show what I am trying to get it to show!
When you send a query to MySQL, you don't get your actual answer.
You get a "Resource ID"
It's more like a Receipt for your answer than your answer.
You then need to use http://php.net/mysql_fetch_row or other functions to
get your actual answer.
It does seem a bit like jumping through "extra" hoops to a newbie, but there
are some behind-the-scenes technical reasons why you don't just get your
"answer"
Something like this would work for the above example, after you GET RID of
the die() part:
if ($rsum){
$ratingsum = mysql_result($rsum, 0, 0);
echo "Rating Sum is $ratingsum<BR>\n";
}
else{
echo "Web-site down for maintenance. Please try again later.<BR>\n";
error_log(mysql_error());
# NOTE: You have 'broken' SQL. Check you Apache error_log to find the
error message
}
If you were getting several rows, it would be more like:
if ($rsum){
while (list($column1, $column2, $column3) = mysql_fetch_row($rsum)){
echo "$column1, $column2, $column3<BR>\n";
}
else{
... same stuff as above
}
--
Like Music? http://l-i-e.com/artists.htm
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
