Could I do this?
mysql_query("UPDATE users SET something+1 WHERE username='1'");

I'm trying to do something like that and it's not working.

It'd be:

Code:

Select All

 

mysql_query("UPDATE users SET something=something+'1' WHERE username='1'");

mysql_query("UPDATE users SET something=something+'1' WHERE username='1'");

 

Thanks rosss

Posted By Ross on 8th Feb 08 at 11:35am

 

It'd be:

Code:

Select All

 

mysql_query("UPDATE users SET something=something+'1' WHERE username='1'");

mysql_query("UPDATE users SET something=something+'1' WHERE username='1'");

 

Actually, it should be:

Code:

Select All

 

mysql_query("UPDATE users SET something=something+1 WHERE username='1'");

mysql_query("UPDATE users SET something=something+1 WHERE username='1'");

 

Numbers shouldn't be inside quotes.

I've always used them in quotes and it works fine. In fact I think I had errors last time I tried with no quotes.

Posted By Ross on 8th Feb 08 at 9:22pm

 

I've always used them in quotes and it works fine. In fact I think I had errors last time I tried with no quotes.

That's odd. I'm sure that I saw on PHP's site that quotes take more time to process than without.

I shall search for it again and see what I find.

I'll have to try no quotes next time then and see if that helps