ok, here is my code without all of the html (sorry people). I'm trying
to get a sum of the field runtime. With this code, I get "Resource id
#3" as an error. Any help getting me to the proper result would be
greatly appreciated.
<?
@$db = mysql_pconnect("localhost","dviewd");
mysql_select_db("dvds");
$query = "select * from list order by title";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
$dvd_time_query = "select sum(runtime) from list";
$dvd_time_result = mysql_query($dvd_time_query);
echo "<td class=m><font size = -1><b>".$dvd_time_result."</b></td>";
?>
Thanks,
Chip
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
