if i had a table structure like this:
[ user , active (yes/no field) , product , qty ]
for a shopping cart kinda thing, how do i insert a product into that table where the user = yes, or active?
Sorry if this has already popped up..
Umm.. i need help with an insert query, but i have to use vb for it..
STORY... I SPOSE..
Its a computer part shopping cart basically..
when a user logs in, a column in the user table called 'active' is set to YES, since its a yes/no field.
When a user goes...
i am trying to insert info from a form into a table.. but thats not my problem..
The info I want insert has to be inserted to the User that is currently "active" in that table. My table structure:
User:
[ userid , username , password ..... active ]
Product:
[ product , name, .... ]
CartOwner...
I have three list boxes running in the one form..
I want it to run so once I select something from the first list box it updates the second, and then click the second and it updates the third.
The first box displays products types..
CPU
Motherboard
etc...
The second I want to...
Hey,
Sorry if this has already appeared in the forums before..
I need help with building a login system..
I have a User table:
userid | username | password
^^ slightly more complez but thats basically it..
I don't know how to do the code for it.. I know it has something to do with a...