Looping to display results....

[Elliott]

Hi, i am trying to loop my results for the seat letter here.
This information is based on there being 1 seat (a) booked on row 1, leaving b, c, and d still available.

now i perform this loop, and say i want to book 3 seats....its only returning the next 2, instead of the next 3. And if i book 2, it only displays the next 1, and if i book 1, it wont display any.

EG..
Row: 1
Seat: b
c

do i have to put a +1 or something somewhere to make it add the extra row? what am i doing wrong?

<?php 
				while ($record2 = mysql_fetch_array($result2))
				{
				$seat = $record2['seat'];


			echo "<tr>
              <td>$seat</td>
            </tr>";

			}
			?> 

Thanks
Elliott

[laserlight]

Not enough information.

Provide the simplest and smallest example of a script that has this problem.