Variables Passing but not updating

[ukgimp]

The script runs fine on my local machine. I transfer to the remote webserver and it does not. I know the variables are being passed as I printed them out to test it.

I made sure the permissions are set to allow update as well.

I have some very simple sql going on:
mysql_query("UPDATE pages SET accepted = 'y' WHERE id = $var")

The include files collect the variables also.

I have this in one of the includes
$_SERVER['REQUEST_URI']
and I have to request the
$_HTTP_SERVER_VARS['HTTP_HOST']

What can I be missing. This is driving me mad. Works locally, knackers remotely.

[ukgimp]

do I need some sort of database prefix?

This seems odd as I can select and insert?

[coopster]

Is $var a text string? Try quoting it:

mysql_query("UPDATE pages SET accepted = 'y' WHERE id = '$var'")

[ukgimp]

done that one. It is a number. The funny thing it is works locally just falls dwon on upload. On the remote other things work.

[coopster]

Don't mean to be too technical, but have to ask, you do have a semicolon at the end of your mysql statement, right? If so, here's how I troubleshoot sql statements, give it a shot and see if anything looks goofy:

$sql = "UPDATE pages SET accepted = 'y' WHERE id = $var";
exit("$sql");
mysql_query($sql);

[ukgimp]

Nothing funny there. All looks well. It just does not do the update.

Baffled, this should not be as hard as brain surgery. :)

[charlier]

Does the mysql_error() function report any errors?

[coopster]

Are you sure you are getting a connection in your mysql_connect() function?

Since you are trying to connect to a different server, maybe you haven't changed your mysql_connect() statement.

Check for errors there and then try running a simple SELECT statement and print the output.

[ukgimp]

Sorry Coop

selects and inserts work fine. I have permissions to allow for UPDATE also of that user. It just appears to be updates.

Cheers

[coopster]

I have no clue at this point...table locked?

[ukgimp]

>>table locked?

How would I tell that?

[ukgimp]

solved

Setting the permissions is fine. BUT and heer it is you have to set reload mysql to get them set.

So thanks and another thing learnt

[coopster]

Cool. I was just about to point you to the MySQL Manual [mysql.com]. Glad you got it!

[ukgimp]

Thanks for your help though. Finding out may well have save my PC's life :) There are 5 story windows nearby dont you know

[coopster]

LOL. We've all been there. Sometimes you just need somebody to troubleshoot with, and that's why we come here.

...another pc spared...