I am trying to put stuff into a MySQl shopping cart using the form (see below) and the data from the form does not appear to get into the cart part of the database.
Any ideas please?
THE FORM:
<form action="https://xxx/~xxx5/ShoppingBag.php" method="POST">
<input type="hidden" name="ITEMID" value="1247001">
<!-- REPLACE PRODUCT ID HERE -->
<table border="0" width="126">
<tr align="right">
<td width="56"><strong>QTY </strong></td>
<td width="66"><strong>COLOR</strong></td>
</tr>
<tr align="right">
<td><select name="QTY" size="1">
<option
selected>1</option>
<option>2</option>
<option>3 </option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8 </option>
<option>9</option>
</select></td>
<td> <select name="COLOR" size="1">
<!-- Color Choices here. First one should have -->
<!-- the 'selected' attribute. -->
<option selected>50735</option>
<!-- End Color Choices -->
</select></td>
</tr>
<tr align="right">
<td colspan="2"><input
type="image" name="I1" src="../Images/ADD-TO-CART.jpg"
align="bottom" border="0" width="126" height="45"> </td>
</tr>
</table>
</form>
THE CART TABLE:
Field Type Attributes Null Default Extra Action
cartId int(11) No auto_increment Change Drop Primary Index Unique Fulltext
cookieId varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext
ITEMID int(11) Yes NULL Change Drop Primary Index Unique Fulltext
QTY int(11) Yes NULL Change Drop Primary Index Unique Fulltext
COLOR varchar(25) Yes NULL Change Drop Primary Index Unique Fulltext
SIZE varchar(25) Yes NULL Change Drop Primary Index Unique Fulltext
THE ITEMS TABLE:
Field Type Attributes Null Default Extra Action
ITEMID int(11) No 0 Change Drop Primary Index Unique Fulltext
ITEMNAME varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext
ITEMCOLOR varchar(25) No na Change Drop Primary Index Unique Fulltext
ITEMSIZE varchar(25) No na Change Drop Primary Index Unique Fulltext
ITEMPRICE decimal(4,2) Yes NULL Change Drop Primary Index Unique Fulltext
ITEMSHIPPING decimal(4,2) Yes NULL Change Drop Primary Index Unique Fulltext
ITEMQTY int(11) No 1 Change Drop Primary Index Unique Fulltext
