2 weeks past due

LanHorizon

i need to have a table that will have loop through the alphabet in succession for each row and for the columns i need to loop through 15 numbers per row up to the maximum of 238. each td cell with a number will need to have a radio button associated with it that carries the value of the number itself.

for example:

when the user selects the radio button for a particular number (say number 8) and then press submit, that number will be stored into a mysql table under the seat column id.

now, when each new user visits this form, the same thing should happen as above, EXCEPT this time the table should not allow the seats that are currently in the database to be selected.

for example:

i also need to be able to define various sizes of spacer cells in between each <td> and each <tr> at various alternating places throughout the table layout...

i have been working on this for the past 2 weeks and am still at ground zero....i am past my deadline and need this done as soon as possible....can someone here please help me?

codeDV

The beauty of the ASCII character set is that each letter A to Z is assigned a consectutive value ie:

A 65 B 66 C 67 ....

Therfore you can use a for loop to create your table. The ord() function returns the ASCII value of any character and the chr() function returns the character from the given ASCII value.

The following will output a table similar to what you described:

<html>
<body>
<table>
<form method="POST" action="row.php">
  <table>
<?php
  $max = 10;

  for ($alpha = ord ('A'); $alpha <= ord ('Z'); $alpha++) 
  {
    echo('<tr><td>' . chr ($alpha) . "</td>\n");

  for ($count = 1; $count <= $max; $count++)
    echo ('<td>' . $count . ' <input name="rows" type="radio" value="' . chr($alpha) .
$count . "\"></td>\n");

echo ("</tr>\n");
  }
?>
  </table>
<input type="submit">
</form>
</body>
</html>

As for ommiting the seats that have already been taken I suggest executing a query on your database before displaying a table and loading the seats which are unavailable into an array. You can then do something like the following:

      for ($count = 1; $count <= $max; $count++)
      {
         $seat = chr($alpha) . $count;

      if (array_search ($seat, $array) === FALSE)
        echo ('<td>' . $count . "</td>\n");
      else
        echo ('<td>' . $count . 
' <input name="rows" type="radio" value="' . $seat . "\"></td>\n");
       }

Here the input field for the radio button is simply ommited.