Shopping Cart Update Quantity Button

middleman666

just started making a shopping cart and im stuck on how to make an update button which once clicked, updates the total/s depending on the number in the textfield in the quantity column.

this is my text field that holds $item_qty:

<input name=\"sel_item_qty\" type=\"text\" id=\"sel_item_qty\" value=\"$item_qty\" size=\"4\" maxlength=\"4\">

I also have an update button, my main problem is I dont know what actions this button should have. I've tried having it reload the page but the quantities go back to there original quantity when they were put in the cart.

Any help would be welcome, thanks.

Just so you know, this is a MySql shopping cart.

I just need a shove in the right and easiest direction, I dont want to be starting something that could have been done a lot simpler with a smaller piece of code.

middleman666

ok..., i made this script for updating quantities, but the id bits not working...

<?php

 session_start();

 //connect to database

 $conn = mysql_connect("localhost", "user", "pass")

 or die(mysql_error());

 mysql_select_db("database",$conn)  or die(mysql_error());


$sel_item_qty = $_POST['sel_item_qty'];
$id = $_GET['id'];

$query = "UPDATE store_track SET sel_item_qty = '$sel_item_qty' WHERE id = '$id'";

mysql_query($query);

    //redirect to showcart page

    header("Location: showcart.php");

    exit;

 ?>

what should I be using insted of:

$id = $_GET['id'];

thanks.