[SOLVED] query not returning correct number of records. please help

[debuitls]

Still no luck im afraid kratsg :'(

 

I made a new proposal to test but all it did was replace the antrim proposal with a new kilkenny proposal (see screenshot)!

 

Ah gad, its breaking my heart.

 

Dont worry about it too much if your out of sugestions at this stage!

 

I appreciate your efforts greatly!

 

 

 

[attachment deleted by admin]

[kratsg]

In the while loop for generating the data.. add this:

 

var_dump($row['bids']);

 

So we can see what's going on.

[debuitls]

Hi kratsg,

 

Here is code and screenshot of output.

 

while($row = mysql_fetch_array($result))
{
echo "<tr onclick=\"window.location='results.php?id=" . $row['proposalid'] . "'\">";
			  echo "<td>" . $row['county'] . "</td>";
			  echo "<td>" . $row['checkin'] . "</td>";
			  echo "<td>" . $row['checkout'] . "</td>";
			  echo "<td>" . $row['budget'] . "</td>";
			  echo "<td>" . $row['adults'] . "</td>";
			  echo "<td>" . $row['children'] . "</td>";
			  echo "<td>" . $row['timeleft'] . "</td>";	
			  echo "<td>" . var_dump($row['bids']). "</td>";
			  				  
			echo "</tr>";
			echo "</tbody>";
}
echo "</table>";

 

 

[attachment deleted by admin]

[debuitls]

Ah gad,

 

Tried so many things to resolve this problem!

 

Turned out it was only a case of changing

 

GROUP BY bid.proposalid

 

to

 

GROUP BY proposal.proposalid

 

Works ok now!