webshop cannot retrieve from multiple tables

[Eddard Startk]

I have an example of an webshop. de webshop works as follow. you can put the information in one table and you can retrieve the information correctly. it wil al be shown in the cart en the checkoutpage. I am stuck for a little while know. Imagine i have a table called "clothes" and every piece of clothes could be available in multiple sizes. i would have the following tables:

 

- clothes

- size

- clothes_size

 

if people choose "like" a T-shirt. they should be able to select a size. I cannot seem to realize this. I can show the clothing and available sizes but when selecting clothes the size wil not be available in the card.

 

the code is as follow:

 

to add an item

------------------------------------------------------

 

    php:<ahref=wagen_management.php?act=add&pid=".$item["artikel_code"].">add item</a>

    ?>

 

 

 

cart_function.php:

---------------------------------------------------

 

    php:// add item to cart

    function add_item_to_cart($id,$quantity) {

           

            // set cookie and store value in session

            setstp();   

 

            // call database connect function

            db_connect();

            // get product id from database

            global $mysql_tablename;

            $sel_products = mysql_query("SELECT * FROM $mysql_tablename WHERE artikel_code=".$id."");

            $item = mysql_fetch_array($sel_products);

            // returns the number of rows in a result, if 1 item exists if 0 item doesn't exists.

            $num_rows = mysql_num_rows($sel_products);

           

            // if item exists then add item to cart

            if ($num_rows >= 1) {

           

            session_regenerate_id(TRUE);

       

            $_SESSION["cart"][$id][0] = $item["artikel_code"];

            $_SESSION["cart"][$id][1] = $quantity;

           

           

            header ("location:".$_SERVER['HTTP_REFERER']);

           

            }

        }

    ?>

 

 

 

cart_management.php

----------------------------------------------------------------------

 

    php:if ($_GET["act"] == "add") {

           

            session_start();

            include "cart_function.php";

            //unserialize($_SESSION["cart"]);

            if (!isset($_SESSION["cart"])) {

               

                // add first item

                add_item_to_cart($_GET["pid"],1);

               

           

            } else if (array_key_exists($_GET["pid"], $_SESSION["cart"])) {

               

                // add 1 to quantity if item in cart already

                add_item_to_cart($_GET["pid"],++$_SESSION["cart"][$_GET["pid"]][1]);

               

            } else {

           

                // add any other items after first item

                add_item_to_cart($_GET["pid"],1);

               

            }

           

        }

    ?>

 

 

 

ps. not my own code