[solved]MySQL problems
Posted: Sat Oct 23, 2004 4:31 am
hi guys,
in my DB ive got a table called "user_settings" which holds one field named "flash" if this field is set to 1 then my flash pages wll load up else my HTML pages will.
the problem is that when users click on the link to change the value (either to 1 or 0) i just insert a new row into the DB rather than modifying what is already there! how sould i query the DB for this scenario?
also, this question is kinda hard to word...if there are multiple users on my webpage, and one of them sets the "flash" field to 0, will this effect all my users? how do i get around this?
thanks ppl!
in my DB ive got a table called "user_settings" which holds one field named "flash" if this field is set to 1 then my flash pages wll load up else my HTML pages will.
the problem is that when users click on the link to change the value (either to 1 or 0) i just insert a new row into the DB rather than modifying what is already there! how sould i query the DB for this scenario?
also, this question is kinda hard to word...if there are multiple users on my webpage, and one of them sets the "flash" field to 0, will this effect all my users? how do i get around this?
thanks ppl!