debuitls Posted September 7, 2009 Author Share Posted September 7, 2009 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] Quote Link to comment Share on other sites More sharing options...
kratsg Posted September 7, 2009 Share Posted September 7, 2009 In the while loop for generating the data.. add this: var_dump($row['bids']); So we can see what's going on. Quote Link to comment Share on other sites More sharing options...
debuitls Posted September 7, 2009 Author Share Posted September 7, 2009 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] Quote Link to comment Share on other sites More sharing options...
debuitls Posted September 8, 2009 Author Share Posted September 8, 2009 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! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.