Gerard, This is a shot in the dark, but does the web server (usually NOBODY, but "crash" in this case? Ominous name!) have an account on the XP box and the appropriate permissions to write to the MySQL database? That's where I'd start, along with checking mysql_error().
Miles At 04:18 PM 8/18/2002 -0400, Gerard Samuel wrote: >Im trying to solve a problem with windows xp. >I have 2 identical scripts with the same db schema. One on FreeBSD >running php 4.2.2/mysql 3.23.49 & the other >on windows xp php 4.2.2/mysql 3.23.52. > >The section of the script is supposed to update a table. >------ >$sql = "UPDATE users SET email='$email' WHERE uid='$uid'"; >$result = mysql_query($sql); >var_dump($result); >if (!$result) >{ > die(mysql_error()); >} >------ > >On the FreeBSD box, $result returns true, but returns false on the windows >box. >The error reported when it was false was "Access denied for user: >'crash@localhost' to database 'crash'" >But according to that error, the connection parameters are correct. >I echoed $sql and ran the output of that in the mysql client, and it >executed successfully on the windows box. >So Im stuck as to what could be causing the error with the windows box. > >Anyone experienced this behaviour before??? >Thx. > >-- >Gerard Samuel >http://www.trini0.org:81/ >http://dev.trini0.org:81/ > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php