vForums: Message Board Support - Updating a row

Topic Rating:	Printable View

Dylan
Junior Member

Posts: 136
Status: Offline
Gender: Male
Joined:

Reputation: 0%

Updating a row (8th Feb 08 at 2:52am UTC)
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.
Back to Top - Link to Post

Ross
Administrator

Posts: 3,709
Status: Offline
Gender: Male
Age: 8 ¹⁄₁
Joined:

Additional Groups:
Support Team

Reputation: 45%

Re: Updating a row (8th Feb 08 at 11:35am UTC)
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'");
Back to Top - Link to Post

Dylan
Junior Member

Posts: 136
Status: Offline
Gender: Male
Joined:

Reputation: 0%

Re: Updating a row (8th Feb 08 at 12:21pm UTC)
Thanks rosss
Back to Top - Link to Post

Marc
vChat Developer

I <3 Rossy

Posts: 3,388
Status: Offline
Gender: Male
Location: Ontario, Canada
Age: 32
Joined:

Additional Groups:
Coding Team

Reputation: 40%

Re: Updating a row (8th Feb 08 at 8:43pm UTC)
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.
Back to Top - Link to Post
rroll.to— Shorten a link, rickroll your friends.

Ross
Administrator

Posts: 3,709
Status: Offline
Gender: Male
Age: 8 ¹⁄₁
Joined:

Additional Groups:
Support Team

Reputation: 45%

Re: Updating a row (8th Feb 08 at 9:22pm UTC)
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.
Back to Top - Link to Post

Marc
vChat Developer

I <3 Rossy

Posts: 3,388
Status: Offline
Gender: Male
Location: Ontario, Canada
Age: 32
Joined:

Additional Groups:
Coding Team

Reputation: 40%

Re: Updating a row (9th Feb 08 at 4:33am UTC)
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.
Back to Top - Link to Post
rroll.to— Shorten a link, rickroll your friends.

Ross
Administrator

Posts: 3,709
Status: Offline
Gender: Male
Age: 8 ¹⁄₁
Joined:

Additional Groups:
Support Team

Reputation: 45%

Re: Updating a row (9th Feb 08 at 10:23am UTC)
I'll have to try no quotes next time then and see if that helps
Back to Top - Link to Post

	Printable View