...

View Full Version : doquery doesn't update



masterofollies
12-18-2008, 01:04 PM
When I run this query it has no errors, it runs but nothing is actually updated. Does anything look wrong to you?


doquery("UPDATE people SET ".$trow['poof2']."=".$trow['poof2']."-".$trow['amountwo'].", ".$trow['poof']."=".$trow['poof']."+".$trow['amountone']." WHERE id='".$loginrow["id"]."' LIMIT 1",);

abduraooft
12-18-2008, 01:16 PM
When I run this query it has no errors, How do you know that?


WHERE id='".$loginrow["id"]."' LIMIT 1",); and that comma at the end is for what?

masterofollies
12-18-2008, 02:19 PM
All my other queries process that way. The limit is to have the query only update that user. So it doesn't attempt to update more.

CFMaBiSmAd
12-18-2008, 02:27 PM
The posted code generates a fatal parse error because of the comma that abduraooft mentioned and the page that code is on never executes.

lokeshshettyk
12-18-2008, 02:31 PM
The comma at the end of the statement makes no sense as abduraooft said and what's with this,

".$trow['poof']."+".$trow['amountone']."

shouldn't that be something like

".($trow['poof'] + $trow['amountone'])."

I am just guessing...

Cheers :)

lokeshshettyk
12-18-2008, 02:32 PM
my mistake, accidentally clicked submit twice - ignore this

masterofollies
12-18-2008, 04:54 PM
The comma at the end of the statement makes no sense as abduraooft said and what's with this,

".$trow['poof']."+".$trow['amountone']."

shouldn't that be something like

".($trow['poof'] + $trow['amountone'])."

I am just guessing...

Cheers :)

Well see maybe that is why it doesn't work. I've used single fields before, but have never used a query field in a query.
The comma is needed between the two update fields because it's adding to one, and subtracting from the other.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum