UPDATE problem with mysql

[calrich]

Hi,

Here's the problem: I have set up a working mysql database on my home computer using an Apache server, where I use php to update the database. It works fine.

BUT.... when I upload it to my website, and try to update the database, nothing happens. It just stays the same. There are no error messages at all. I can read data from the database, but can't update.

I've also tried "granting update" to the table, but this hasn't made a difference.

I hope someone knows the answer!! Thanks in advance,

Callum

[Anon]

Maybe Provider didnt support php .
Or is it a redirection to your System ?

Have you checked user table in mysql database for allowed iprange for the user you take ?

[[deleted]]

do you have proper error-checking in your script? ie: you do not use the @ sign to surpress errors, and you do print mysql_error() whenever an error occurs?

[calrich]

Thankyou both for your help. The problem was that it was read-only, and I didnt have the right access privileges to grant update to it. Its getting sorted out now. :-)

Callum