error in INSERT oparation on database in MySql server 3.23.5
Posted: Thu Aug 10, 2006 5:58 am
I am using PHP 4.4.1 to create database in MySql server 3.23.58 running on Unix server. I ran into the following problem.
If I create datbase and tables through phpMyadmin, I am able to run all the DML commands on the database. But, using PHP script and using the same UserId and password, I could create the database and tables, but unable to insert rows into the tables. Our Server Support says that the this database is not in the same group in which the other databases are and this group does not have the required permissions.
Is there a way I can run insert and update scripts from PHP script?
If I create datbase and tables through phpMyadmin, I am able to run all the DML commands on the database. But, using PHP script and using the same UserId and password, I could create the database and tables, but unable to insert rows into the tables. Our Server Support says that the this database is not in the same group in which the other databases are and this group does not have the required permissions.
Is there a way I can run insert and update scripts from PHP script?