[thelist] reworded MySQL query insert and back again

rudy r937 at interlog.com
Tue Feb 11 13:47:01 CST 2003


> 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