[sambar] Desperately Need Help with Sambar and PHP

[Michael Cook]

I'm pretty sure that the problem is, as you say, the varibles not getting passed.  If I try to echo the variables to the screen, they don't appear there either, but a row does get created in the MySql (as a result of the autoincrement field).  So I've ruled out a bad dB connection.  The thing is, I am able to get this to work with th Apache web server, but I'm hell bent on staying with Sambar.   Mike >>> [EMAIL PROTECTED] 2004-05-18 9:21:20 PM >>> I wouldn't think his auto-increment would kick the new record out if that were not true.. sounds like the variables are not getting passed along properly.. You doing any logging in mysql.. since PHP is connecting native to mysql I would assume you would have to trace the mysql db to see what is going across. If it is a permission problem you should see that as well. Danny On 18/May/2004 23:08:24, Peter wrote: > 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/ > > > > > > > ------------------------------------------------------- To unsubscribe please go to http://www.sambar.ch/list/