Confused about how to use UPDATE in Mysql

[Redlightpacket]

I want to be able to update data to one particular table each time a user submits their data to a table in a database. There will be different users logging in so I want the update statement to change to that particular user and update data to that particular table with the user logged in. Is this possible or do you go about this another way? I don't know how to do this. Could you give me an example of something that works.

 

 

Thanks.

[corbin]

Have you read any MySQL tutorials?  That's about as basic as it gets with MySQL x.x.

 

 

 

UPDATE sometable SET somecolumn = 'some value' WHERE username = 'Some User';

[Redlightpacket]

UPDATE $sometable SET somecolumn = 'some value' WHERE username = 'Some User';

 

Can you put a $ in sometable  ???????????

[corbin]

Of course you can.  A query is just a string, and MySQL doesn't know/care where it came from when you pass it to mysql_query.

[Maq]

Side note - Only double quotes will interpolate, single quotes will not.