Thanks for everyone's indulgence, I figured out the problem. simple syntax around the INSERT as follows with the mysql_query.
mysql_query("INSERT INTO docprouser (id,valid,password VALUES('root','y',md5('ksobhinyai'))"); Blessings, Chetan > I am having problems with the MySQL DB. It started with this command from > a call in a PHP script... > > "INSERT INTO docprouser (id,valid,password)VALUES > ('user5','Y',md5('ksobhinyai'));" or die(mysql_error());" > > The script actually connects with the DB fine and no errors at all. You > can see the screen output in the attatched text file. However, there is > no new entry in DB. > > Upon looking at the error log for the specified time I get: > > **Query Execute Thread cannot connect to MySQL ** > > However, if I cut/paste the above into the query window of GUI it executes > just fine, and shows the record written. > > I've dnloaded the latest OBDC connector and set up correctly. > I've googled the MySQL errors to no avail. > TCP/IP is active on pc. > The tables were even created with this script. > > I'm beyond frustrated, as two days now have been stuck with this DB > problem. I just spent the last five or six hours deleting the DB off the > server and reloading it several times which cleared up several previous > problems. Now, it comes down to this one. > > Any help would be appreciated. > Blessings, > Chetan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php