hi Guys, thanks for your comments. sorry about the code tags. I've changed the code and it's now filling the table to a certain point, but just not right yet. http://www.tropicalexperience.com.au/info.php?seeinfo=2139 <php? $q = mysql_query("SELECT season_room.id, room.name AS rname, room.capacity AS rcap, rates.min_nights As rnts, rates.rate FROM room LEFT JOIN season_room ON season_room.roomid = room.id LEFT JOIN rates ON season_room.id = rates.season_roomid WHERE room.itemid = '$item'"); while ($r = mysql_fetch_array($q)) { echo '<tr><td>'.$r[rname].'</td><td>'.$r[rcap].'</td>'; echo '<td>'.$r[rnts].'</td><td>'.$r[rate].'</td></tr>'; } ?> Can anyone see a better way of doing this? I've spent ages at it now and just don't seem to be getting anywhere fast.