display results in loop in tab pannels

[searls03]

what I need is for a loop to run to make tabbed pannels according to categories.  then I need the buttons to be put into the correct tab based on the category it falls under.  then a subcategory tabs inside the other tabs for products that have that specific sub category.

 

here is what I sorta made....it doesn't work though....

 

<div id="TabbedPanels1" class="TabbedPanels">
        <ul class="TabbedPanelsTabGroup"><?php $sql = mysql_query("SELECT * FROM categories");
while($row = mysql_fetch_array($sql)){
$category = $row["category"];
$sub =$row["subcategory"];
?>
          
<li class="TabbedPanelsTab" tabindex="0"><?php echo $category; ?></li>
<div class="TabbedPanelsContentGroup">
<div class="TabbedPanelsContent">
<?php
// set layout vars
$x = 1; // set $x
$start = array ('1', '10', '19', '28', '37', '46', '55', '64', '73', '82', '91', '100', '109', '118', '127', '135'); //columns will be started at each of these numbers
$end = array( '9', '18', '27', '36', '45', '54', '63', '72', '81', '90', '99','108','117', '126' ); // set numbers to end columns at
?>

        <?php echo '<table border="1px" cellpadding="0px" cellspacing="0px" ><tr height=\'50px\'>'; //start the table, and the row.
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM products where category=".$category."");
while($row = mysql_fetch_array($sql)){
$product = $row["product"];
$id =$row["id"];
$price =$row["price"];
if (in_array($x, $start)) { // if x equals a number in the start array
echo '<td width="100">';                   // start a column
} ?> 

     <?php $sql = mysql_query("SELECT * FROM categories");
while($row = mysql_fetch_array($sql)){
$category = $row["category"];
$sub =$row["subcategory"];
?>
          
<?php
}
?> 
      
       
    <div id="products">
      <form action="" method="POST" name="myform<?php echo $id; ?>" class="myform<?php echo $id; ?>"> 
        <input type="hidden" name="hiddenField" class="hiddenField" value="<?php echo $product; ?>" />
        <input type="hidden" name="hiddenField2" class="hiddenField2" value="<?php echo $id; ?>" />
        <input type="hidden" name="hiddenField1" class="hiddenField1" value="<?php echo $price; ?>" />
      <input type="submit" name="submit" class="submit" value="<?php echo $product; ?>" style="background-color:lightgreen; height:50px; padding: 0px; margin:0px; width:100px;">   </form>
    </div>   
<?php
if (!in_array($x, $end)){ // if $x equals anything OTHER than 9, 18, etc - put in a line break
} else { // else if it DOES equal 9, 18 ,etc end the column
echo '</td>';
}
$x ++; // increase x to keep count
} // while loop ends
//now outside of the loop, 
$x = $x - 1; //subtract the last $X++ so you know exactly how many buttons were added
if (!in_array($x, $end)){ // if $x equals anything OTHER than 9, 18, etc - end the column as it wouldn't have ended itself
echo '</td>';
}
echo '</tr></table>'; // close the row and table

?><?php
}
?>             </div>     

   </ul>
       
      </div>  

 

any help is greatly appreciated.