[thelist] reworded MySQL query insert and back again
Andrew Maynes
andrew at humanbehaviour.co.uk
Tue Feb 11 16:03:01 CST 2003
this is the bit that is really doing my head in... this is the diplay for the
color select
echo "<SELECT name=\"ColorName\" value=\"$ColorName\">";
showColor($II);
echo "</SELECT> ";
> mysql("$DBName","INSERT INTO CartItems VALUES
>>
>('$UID','$ItemID','$ItemQuantity','$Date','$CartItemsID','$ColorName','$size
>')")
>
>where do these values come from?
>
>let me guess -- a web page form
>
>for colour and size, are you using <SELECT> with <OPTION> ?
>
>what are the values in the option tags?
>
>they should be the id numbers of the colour and size names
>
>
>
>rudy
>
More information about the thelist
mailing list