[PHP] checkboxes into MySQL(trying again)

[Jerry Lake]

sorry about that,
I forgot to erase the old post
info

here is a chunk of the code I am using
<snip>
//inclusion of pizza toppings from DB
$query = ("SELECT * FROM toppings");
$result2 = mysql_db_query($DBName, $query) or
die("Error in MySQL query");

echo "<table border='1' cellpadding='2' cellspacing='2'>";
echo "<tr bgcolor=" . $colors[ $i ++ % count( $colors ) ] . ">";

$colors = array( '#e4e4e4', '#ffffff' );
 
$i = 0;

while($myrow =  mysql_fetch_array($result2)) {
        $counter++;
        if ($counter > "4") {
           $counter = "1";
                echo "</tr><tr bgcolor=" . $colors[ $i ++ % count( $colors ) ] . ">";
        }
$name = $myrow["name"];
$personal_cost = $myrow["personal_cost"];
$small_cost = $myrow["small_cost"];
$medium_cost = $myrow["medium_cost"];
$large_cost = $myrow["large_cost"];
$category = $myrow["category"];
</snip>

<snip>
echo "<td valign=top align=left>\r\n";
echo "<input type=checkbox name=".$name." value=".$cost.">".$name."</td>";
echo "</td>\r\n";
}
if ($counter < 3) {
while ($counter < 3) {
        echo "<td>&nbsp;</td>";
        $counter++;
}
}
echo "</tr>";

echo "</table>";
// memory flush
mysql_free_result($result2);
//end topping section
</snip>

Jerry Lake            - [EMAIL PROTECTED]
Web Designer
Europa Communications - http://www.europa.com
Pacifier Online     - http://www.pacifier.com



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]