[thelist] reworded MySQL query insert and back again
Andrew Maynes
andrew at humanbehaviour.co.uk
Tue Feb 11 10:04:13 CST 2003
Rudy I really dont think the temp_table can be removed as this contain sthe
orders of the visitor. I could be wrong though! If the users records are not
going to be held here until check out where will they be held?
ok the table logic is this......
'ref_colours'
ColorName ColorName
blue 1
black 2
green 3
'item_color'
id item_id color_id
auto 1 1
1 2
1 3
2 2
3 2
3 3
Temp_Table
UserID ItemID ItemQuantity Date CartItemsID ColorName size
1 1 1 ddmmyy 1 3 whatever
so the problem is the 3 I have tried almost everything except what I should have
I guess to get 'green' inserted instead of 3
Andrew
>can you please make up the sample rows i asked?
>
>for example, i will do the second of the three ("kumquats are small gray and
>small grey") in the manner that i suspect you have designed your
>relationship table --
>
>11 210 102
>11 210 101
>
>i'll address your insert logic once i see what your table looks like
>
>and i remain convinced that this can all be done without a temp table
>
>be ready to ditch it, okay? ;o)
>
>
>rudy
More information about the thelist
mailing list