Shopping cart for multiple tables

[ashraf02]

basicaly i am creating a shopping cart for my website however creating a shopping cart for one table of items is easy but can someone direct me on how to create a shopping cart that can handle more than one table of items. i really need ur help on this

 

thanks

 

ashraf

[Zhadus]

I think you need to go into a little bit more detail in explaining what you are trying to do, perhaps an example of what you HAVE done and what needs to change or what you're trying to incorporate.

[ashraf02]

i will post the code i have made below which works. however i want to add some more code so it can work for another table aswell. at the moment it works for my shirts table. i also want it to work for my trousers table.

 

ashraf

 

code

 

<?php
session_start();

$conn = mysql_connect("localhost", "root", "")
or die (mysql_error());
mysql_select_db ("noble", $conn) or die (mysql_error());

if ($_POST[bas_Item_ID] != "") {
$shirt_info = "SELECT Shirt_Brand
			   FROM Shirts
			   WHERE Shirt_ID =$_POST[bas_Item_ID]";
$shirt_info_res = mysql_query ($shirt_info) or die (mysql_error());

if (mysql_num_rows ($shirt_info_res) < 1) {
	header ("Location: Display_Smart.php");
	exit; 
} else { 
 	$shirt_brand = mysql_result($shirt_info_res,0,'Shirt_Brand');

	$addcart = "INSERT INTO Basket 
				VALUES ('','$[COOKIE]PHPSESSID', '$_POST[bas_Item_ID]', '$_POST[bas_Item_Qty]', '$_POST[bas_Item_Size]',
				now())";

	mysql_query($addcart);

	header("location: Showcart.php");
	exit;
}

    } else {
	header ("Location: Display_Smart.php");
	exit;
}

?>