seperation problem

[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

[[deleted]]

I think this is the problem:
while ($row=mysql_fetch_array($mysql_result))

try to change it to:
while (list(order_id,item,price)=mysql_fetch_array($mysql_result))

or
while ($row=mysql_fetch_array($mysql_result) and ($count++)<number)
|
|
number of records you want

yours
shakespeare

[g7pwx]

ok 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; here is the process.

$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";

[[deleted]]

I think your code is perfectly good,you can get what you want
but i suggest use a variable to replace "milk" in
$sql="INSERT INTO order_line (item, price, order_id) SELECT shop.item, shop.price, ".$tran_ID." FROM shop WHERE shop.item='milk'";

now ,you use the "while......" code section to list all your shop have,
and then acustomer select one good she(or he) like,the seperation code work.that's all,right?

so what's your problem

yours
shakespeare