RE: [PHP] Need Help - past deadline

Ok - Thanks to Jim Lucas off list - I am almost to where i want to be, but i am unable to reach him for further assistance. Can someone tell me where in this code I can add a grey table row seperator? AND how come only the first seat from my database is being displayed as taken? $alphabet = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q'); $rowCount = 14; $totalSeats = 238; $connection = mysql_connect("localhost","******","*******") or die ("Couldn't make connection."); $db = mysql_select_db("registration", $connection) or die ("Couldn't select database."); $sql = "SELECT seat, alias FROM attendees"; $sql_result = mysql_query($sql,$connection) or die("Couldn't execute query."); $row = mysql_fetch_array($sql_result); $alias = $row['alias']; ?> <center> <table class="seattable" width="650"> <?php for($i=0; $i<$totalSeats; $i++) {

    $val = $i + 1;
    if($i % $rowCount)
    {
        echo "<td align=\"center\" valign=\"middle\" ";
    }

    else
    {
        echo "<tr>";
        echo "<td align=\"center\" valign=\"middle\" class=\"rowheader\">";
        echo $alphabet[($i / $rowCount)];
        echo "</td>";
        echo "<td ";
    }

    if(in_array($val, $row))
    {
        echo " class=\"closed\"><a class=\"sold\" title=\"SOLD TO $alias\" onMouseOver=\"self.status='SOLD TO ".$alias."'; return true;\" onMouseOut=\"self.status=' '; return true;\">";
        echo "{$alias}";
    }

    else
    {
        echo " class=\"open\">";
        echo "<input type=\"radio\" name=\"seat\" value=\"{$val}\"><font class=\"avail\">{$val}</font>";
    }

    if($i % $rowCount + 1)
    {
        echo "</td>";
    }

    else
    {
        echo "</td></tr>";
    }

} ?> </table> </center> here is what I am wanting to add - I tried placing this in several places in this code so far (top, middle & bottom) but whenever i add it, the output gets totally fudged.... <tr> <td class="rowspace">&nbsp;</TD> <td class="space" colspan="15">&nbsp;</td> </tr> but I also need it to display ALL of the seats that are in the db as being sold and not just the first row... TIA ================================================ Jay Fitzgerald, Design Director - Certified Professional Webmaster (CPW-A) - Certified Professional Web Designer (CPWDS-A) - Certified Professional Web Developer (CPWDV-A) - Certified E-Commerce Manager (CECM-A) - Certified Small Business Web Consultant (CWCSB-A) Bayou Internet - <http://www.bayou.com/>http://www.bayou.com Toll Free: 888.30.BAYOU (22968) Vox: 318.338.2034 / Fax: 318.338.2506 E-Mail: <mailto:jayfitz@bayou.com>jayfitz@bayou.com ICQ: 38823829 / AIM: bayoujf / MSN: bayoujf / Yahoo: bayoujf ================================================