Click to See Complete Forum and Search --> : INSERT does not work in php pages but works in phpMyAdmin


ratso
10-06-2002, 11:08 AM
INSERT into does not work in php pages but works in phpMyAdmin

I have just moved my development environment from windows to linux, and I can communicate with MySQL (SELECT, INSERT, CREATE etc) with PhpMyAdmin and MySQLnavigator, and my php scripts will SELECT but whenever I use INSERT it does not work

All my scripts were copied straight from the webserver where they are working okay.

I have checked my user rights and they are all selected

Anyone have a clue as to what could be happening?

Thanks

jstarkey
10-06-2002, 02:41 PM
Have you tried echo'ing mysql_error() after the insert statements?

ratso
10-06-2002, 03:14 PM
I found the problem

In my new installation of php register global vars was off

When on my old installation it was on

apparently this is not a good thing, but I am still learning!!

Thanks for your help anyway

Ratso