I appologize in advance for my niavété since I'm rather new to the PHP world but I'm having some problems with this. I have mySQL set up and I've been receiving information from it through PHP with no problem, but when I try to change information through it with an Updateable query it does not do it. I try it directly in mySQL and it works fine.

My only explanation is I have not set up mySQL right or my permissions are not set correctly to do this sort of query.

If anyone could help me, I would appreciate it greatly.

- mccareth

P.S. I'm not sure it pretains, but I'm using mySQL and PHP on Windows.

When I put in the Errno and Error functions into my PHP page it returned a 0 with no Error message, so I'm under the assumption that like most other languages, that meant the query went through fine. Perhaps I'll post my code and let you guys see what I've done, maybe there is something that needs to be added that I've missed.

I was just playing around and thought for the heck of it, I'd replace my Updateable query to a Delete query... Same problem as the update query. It tells me that there are no errors in executing, but it just won't delete the record, but likewise to the update query I have no problem in executing it directly in MySQL.

Sometimes strange things can happen when using ' and " because it may do something a little different then expected.
print out the query on the page after you build it, then you know exactly what php is executing, might be a little different than expected.