Stab in the dark, the user you created for mySQL has insert priv?
-----Original Message----- From: "Michael Cook" <[EMAIL PROTECTED]> To: "sambar List Member" <[EMAIL PROTECTED]> Date: Tue, 18 May 2004 16:40:55 -0400 Subject: [sambar] Desperately Need Help with Sambar and PHP > Hi folks, > > My PHP (4.3.6) and MySQL (4.0.18) install on Sambar (5.2) has taken a > turn for the weird. I can get complex PHP scripts like PHPMyAdmin, and > PHPbb to perform flawlessly. My own PHP scripts that contain sql > SELECT > * (to view all records for example) also work just fine. > > But when I try to execute the simplest sql insert (my own or using a > code generator like PHPCode Ginni) a record is created in the MySQL > table (because the table has a field with autoincrement) but the form > variables are not passed to the sql INSERT. > > I'll reiterate that even PHP code containing sql INSERT that was > "professionally" done (i.e. with PHPCodeGinni) does not work. > > I find this hard to believe because the webs apps like PHPMyADmin and > PHPbb, use sql INSERTS in their code to populate/alter MySQL tables. > So > what in the world could it be that would prevent my PHP scripts (and > code generated scripts) containing sql INSERT code to work? > > Has anyone had this sort of strange behaviour? > > Thanks in advance for your replies. > > Mike > > > > > > > > ------------------------------------------------------- > To unsubscribe please go to http://www.sambar.ch/list/ > > ------------------------------------------------------- To unsubscribe please go to http://www.sambar.ch/list/
