[Resolved] UPDATE not working, no error msg??? Help :(

twilson

I am totally confused about this.

I am running this code at the bottom of my script:

mysql_free_result($QUERY);
	unset($QUERY);

foreach ($Completed_IDs as $ID) {
	$UPDATE_QUERY_Str = "UPDATE special_lists SET completed=1 WHERE id=".$ID;
	$UPDATE_QUERY = mysql_query($UPDATE_QUERY_Str, $LocalDB) or die('MySQL Error: '.mysql_error().' | Query: '.$UPDATE_QUERY_Str);
}

This is the output I get:

MySQL Error:  | Query: UPDATE special_lists SET completed=1 WHERE id=7

The only other line of code pertaining to this table in the script is at the top, it is:

$QUERY = mysql_query("SELECT special_lists.id as id, special_lists.area, special_lists.sponsor_id, users.email FROM special_lists, users WHERE special_lists.completed='0' AND (special_lists.user_id=users.user_id)", $LocalDB);

if (DEBUG) {
	echo mysql_error();
}

while ($Data = mysql_fetch_array($QUERY, MYSQL_ASSOC)) {
 //do some stuff
}

And as the subject explains, the UPDATE doesn't do anything. If I copy/paste it into phpMyAdmin and run it, it does update though.

Any thoughts?? 🙁

Thanks in advance,
Tom 🙁

sneakyimp

looks weird to me. i would imagine that your code would work. since your query is an UPDATE query, you really don't need to put the result into a variable...instead of this:

$UPDATE_QUERY = mysql_query($UPDATE_QUERY_Str, $LocalD😎 or die('MySQL Error: '.mysql_error().' | Query: '.$UPDATE_QUERY_Str);

maybe try this:

mysql_query($UPDATE_QUERY_Str, $LocalD😎 or die('MySQL Error: '.mysql_error().' | Query: '.$UPDATE_QUERY_Str);

UPDATE queries will return true or false rather than a database resource.

twilson

I know. It's rediculous. I was thinking maybe it's because that first query relies on the completed field, but that query should be buffered. I've done this sort of thing a million times.

I tried your idea to no avail. Doesn't hurt to try though... Anyone else seen this issue?

Here's some additional info:

MySQL version 4.0.14-log
PHP version 4.3.10

Thanks,
Tom

twilson

I feel like a moron.

To save everyone else some time, learn a lesson from me:

When initializing the database connection, make sure you are using a username with WRITE permission to the database.

It apparently doesn't return an error if you try to write and don't have access.

Thanks for the answers.

Peace,
Tom

sneakyimp

thanks for letting us know. that's something it would be really hard to find out.

WebRuss

Originally posted by twilson
I feel like a moron.

Peace,
Tom

As you should :p

WebRuss