selecting different items

g7pwx

Ok wonder if anyone can help with this. I am trying to select data stored in a database as u can see and it gets dispalyed. But my problem is I need to beable to select each item individually instead of all at once or 1 item only. I need to beable to select say bread as an item and milk as an item but at the moment I can only select 1 or all items.

Thanks.

$sql="select * from shop";


$mysql_result=mysql_query($sql,$connection);
$num_rows=@mysql_num_rows($mysql_result);


if ($num_rows == 0) {
echo "The Shop Is Closed";
} else {
while ($row=mysql_fetch_array($mysql_result))
{
$tran_ID=$row["order_ID"];
$item=$row["item"];
$price=$row["price"];
?>
<?
echo "<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" width=\"15%\"><center>
<tr><td>$item : </td><td> £ $price</td><tr><td></td></tr></tr></center></table>";
}


}  # end else

ryza_

example
$sql="SELECT * FROM table_name WHERE id='1'";

g7pwx

I know this but i need seperate buttons to select an item and put it into a cart.

so select * from shop;

shows me the whole shop

then say next to milk i need a button to drop that into the cart. At the moment it will only let me select 1 item and no others.

hence;

$sql="INSERT INTO order_line (item, price, order_id) SELECT shop.item, shop.price, ".$tran_ID." FROM shop WHERE shop.item='milk'";
//$sql="insert into order_line (order_id) values ($tran_ID)";
if (!mysql_query($sql,$connection)) {
echo "Error cannot add items..Please Contact the Administrator";
echo "<BR>Back to <A HREF=\"c_order2.php\"> Stationay Order</A>";
   exit;
  } else {
# insert OK inform user
echo "Table updated [".mysql_affected_rows()."] item(s) added<BR>";
echo "<B>Items added to basket...</B><BR>";
echo "$item  £$price";

dr_froyd

Heres a lil idea u can try urself

In the page you use to show ur itens make the while loop print a checkbox for each produtc u have, letting users click one or more boxes.
Set the name of your checkbox to something like an array like:

So the trick is, make a single button that add the selected products to the cart .... HOW ? Like this ...

All the marked items will be submitted to server as an array,
Loop in the array and MAKE AN INSERT for each item of it !
Just tell me if you want some code for that ....

Hope this help ...i can see ur logged right now ... lets keep doing it !
Im still waiting for help too ...

🙂

g7pwx

Yes i can see the idea just getting my head around it.

i use the process above to add the item to the cart (order_line) can that still be ude in this case?