checkbox
hey jeg have indsat en et par checkboxe på min side som hentest fra en db men hvordan påføre jeg det i min SQL streng så det kommer med i DB<?php
$sort = $_GET['sort'];
$orderid = $_GET['orderid'];
if ($sort == ""){
$sort = "nr";
}
$sort2 = $_GET['sort2'];
if (sort2 == ""){
$sort2 = 0;
}
if ($sort2 == 0){
$sort2 = 1;
}else{
$sort2 = 0;
}
if (sort2 == 0){
$sort3 = "";
}
if($sort2 == 1){
$sort3 = "DESC";
}
include('db.php'); /* login til min DB */
$result = mysql_query("SELECT * FROM mad_menukort ORDER BY $sort $sort3");
if ($orderid == ""){}else{
$pizza1 = mysql_query("SELECT * FROM mad_menukort WHERE nr = $orderid");
$pizza2 = mysql_fetch_array($pizza1);
echo "Du har bestilt: ".$pizza2['navn'].".";
$pizzapris = $pizza2['pris'];
$pizzanavn = $pizza2['navn'];
$result2 = mysql_query("SELECT * FROM bestilt");
mysql_query("INSERT INTO bestilt (nick, pris, pizzanavn, statusid, dato) VALUES ('*NICK DATA*', '$pizzapris', '$pizzanavn', 'Afventer', now()) ");
?><META http-equiv="refresh" content=";URL=http://www.g-lock.dk/sh/bruger.php"> <?php
}
echo "<table border='1'>
<tr>
<th><a href=?sort=nr&sort2=".$sort2.">nr</a></th>
<th><a href=?sort=navn&sort2=".$sort2.">navn</a></th>
<th>type</th>
<th>indhold</th>
<th>chili</th>
<th>hvidløg</th>
<th>pris</th>
</tr>
<form method=\"post\">";
while($row = mysql_fetch_array($result))
{
$nr = $row['nr'];
echo "<tr>";
echo "<td>" . $row['nr'] . "</td>";
echo "<td>" . $row['navn'] . "</td>";
echo "<td>" . $row['type'] . "</td>";
echo "<td>" . $row['indhold'] . "</td>\n";
echo "<td><input type=\"checkbox\" name=\"chili[$nr]\"></td>\n";
echo "<td><input type=\"checkbox\" name=\"garlic[$nr]\"></td>\n";
echo "<td>" . $row['pris'] . "</td>";
echo "<td><a href=?orderid=".$row['nr'].">Bestil den</a></td>";
echo "</tr>";
}
echo "</table>";
echo "</form>";
mysql_close($con);
?>
