Neverside

sum trouble

If got this query ("SELECT sum(comment_rating) AS total From comments WHERE link_name='affilate'") that works fine when I run it through phpmyadmin but I just can't echo it.

PHP:

<?php
$query = "SELECT sum(comment_rating) AS total From comments WHERE link_name='affilate'";
$result = mysql_query($query);
$row = mysql_fetch_row($result);
echo $row['total'];
?>

whats wrong?

___________________

Comming soon.....The Lord of The Links

That's because mysql_fetch_row returns an enumerated array - if you
want to refer to the result by $row['total'] (rather than $row[0]) use
mysql_fetch_array instead.

sabrina,

Thanks you've been a great help, now I can stop banging my head against the wall.

Cheers,

___________________

Comming soon.....The Lord of The Links

great pun

___________________

For retrieving a single value use mysql_result instead as it will work faster.

PHP:

<?php

$sum = mysql_result($result, 0);
echo $sum;

?>

Radley,

Cheers

___________________

Comming soon.....The Lord of The Links

always die on mysql_error() when you do a query, ALWAYS

___________________

Current Project: LivermoreMuscle.com
Sig Hosted by Motorspin

Quote:

Originally posted by Adam
always die on mysql_error() when you do a query, ALWAYS

Cheers Adam

___________________

Comming soon.....The Lord of The Links