Re: FN-FORUM: PHP - Resource id #5

date posted 10th January 2006 22:47


$dons = mysql_query ("SELECT SUM(donation) as sumDonation FROM thegame");
while($tmpOb = mysql_fetch_object($dons) {

print "TOTAL DONATIONS MADE: " . $tmpOb->sumDonation;

}

unset($tmpOb);
mysql_close($dbh);
unset($dbh);

Best Regards

John

----- Original Message -----
From: "Kevin Choppin" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Tuesday, January 10, 2006 11:08 PM
Subject: FN-FORUM: PHP - Resource id #5


>
> Hi folks,
>
> What am i doing wrong here? This should return the total of all the
> donations in the donation column. But it just returns "Resource id #5". I
> know its usually the variable, but it isnt ive already tried changing it.
> Can anyone help? Its probably right under my nose.
>
>
>
> Many Thanks
>
> Kev
>
> _________________________________________________________________
> Are you using the latest version of MSN Messenger? Download MSN Messenger
> 7.5 today! http://messenger.msn.co.uk
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>