[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