PHP Code:

$getWonItems = mysql_query("SELECT auctionid FROM probid_winners WHERE buyerid='$id'");
while ($wonItems=mysql_fetch_array($getWonItems)) {
$mysql = "SELECT SUM(winamount) AS total FROM probid_auctions WHERE id='$wonItems'";
$earned = mysql_query($mysql) or die(mysql_error());
while($row = mysql_fetch_array($earned)){
$total = $row['total'];
}
} 


I get a resource id #24 error

Any help is greatly appreciated!

The bug is likely in these two lines:

PHP Code:

while ($wonItems=mysql_fetch_array($getWonItems)) {
$mysql = "SELECT SUM(winamount) AS total FROM probid_auctions WHERE id='$wonItems'"; 


$wonItems=mysql_fetch_array($getWonItems) sets $wonItems to be an array. In the next line, you are trying a "WHERE id='$wonItems', but you can't use an array like that in a SQL error.

Hope that helps.

Yeah, I figured that's what it would be. Thanks for verifying that.

Anyone have any suggestions on how I could get this to work?

ok so I realized a silly error, but it didn't completely solve the problem...

PHP Code:

$getWonItems = mysql_query("SELECT auctionid FROM probid_winners WHERE buyerid='$id'");
while ($wonItems=mysql_fetch_array($getWonItems)) {
$mysql = "SELECT SUM(winamount) AS total FROM probid_auctions WHERE id='".$wonItems['auctionid']."'";
$earned = mysql_query($mysql) or die(mysql_error());
while($row = mysql_fetch_array($earned)){
$total = $row['total'];
}
} 


The bolded part is what I changed. Ok so now.... the mysql_query on the first line does output multiple "auctionid"s which is perfect. The problem comes up on the 3rd line I believe because only 1 ".$wonItems['auctionid'] is used.

any ideas for the /\ post?

sorry, but I still need some help with this... so I had to bump it

Are you still getting mysql errors?

I'm not getting any errors now, but it's not doing what I want it to... well not entirely anyway.

refer to post #4

PHP Code:

// Declare value of total
$total = 0;
// Start loop
$getWonItems = mysql_query("SELECT auctionid FROM probid_winners WHERE buyerid = '$id'");
while ($wonItems = mysql_fetch_array($getWonItems))
{
  $getEarned = mysql_query("SELECT SUM(winamount) AS total FROM probid_auctions WHERE id = '" . $wonItems['auctionid'] . "'");
  $earned = mysql_fetch_array($getEarned);
  
  // Add total
  $total += $earned['total'];
} 


Genius! Worked like a charm! I would have never thought of that!

Thanks!