RE: [PHP-WIN] cannot write to mySQL database

2002-03-04 Thread Kriegers Horst
PROTECTED]] > Date: lundi, 4. mars 2002 18:27 > À:[EMAIL PROTECTED] > Objet:Re: [PHP-WIN] cannot write to mySQL database > > > "Nicole Amashta" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Could

Re: [PHP-WIN] cannot write to mySQL database

2002-03-04 Thread Nicole Amashta
In that case, you probably could have accessed your variables like so: $HTTP_POST_VARS["action"] or $HTTP_GET_VARS["me"] Depending on how the variables were submitted (POST or GET). Nicole www.aeontrek.com Pilotdave <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED].; > Woohoo, the

Re: [PHP-WIN] cannot write to mySQL database

2002-03-04 Thread pilotdave
Woohoo, the problem seems to have been register_globals being off. In reading the php.ini info about it, it sounds like having it on can be dangerous. I tried following the instructions in the manual about using variables with register_globals off but couldnt get it to work so i just turned it o

RE: [PHP-WIN] cannot write to mySQL database

2002-03-04 Thread Athene McGregor-Macdonald
ubject: Re: [PHP-WIN] cannot write to mySQL database Ok, making progress. My updated code is below. with full error checking, i get no errors on loading the page. I do get an error when i attempt to submit. It does not recognize $action as being a variable: [Mon Mar 04 13:46:33 2002] [error] PHP

Re: [PHP-WIN] cannot write to mySQL database

2002-03-04 Thread pilotdave
Ok, making progress. My updated code is below. with full error checking, i get no errors on loading the page. I do get an error when i attempt to submit. It does not recognize $action as being a variable: [Mon Mar 04 13:46:33 2002] [error] PHP Warning: Undefined variable: action in c:\homepa

Re: [PHP-WIN] cannot write to mySQL database

2002-03-04 Thread Nicole Amashta
Also, for the sake of testing, replace with the actual script name. Nicole www.aeontrek.com "Nicole Amashta" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED].; > Another thing I suggest is, instead of relying on the value from $submit > (your submit button), create a hidden field an

Re: [PHP-WIN] cannot write to mySQL database

2002-03-04 Thread Nicole Amashta
Sorry, i lost the { in my code. Below it is corrected. If ( $action == "submit" ) { ## do your insert query here } else { ## display the form } "Nicole Amashta" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED].; > Another thing I suggest is, in

Re: [PHP-WIN] cannot write to mySQL database

2002-03-04 Thread Nicole Amashta
Another thing I suggest is, instead of relying on the value from $submit (your submit button), create a hidden field and call it "action" or whatever you want that makes sense to you. This hidden field will store the value of the action you will take when the form is submitted. For example, you ca

Re: [PHP-WIN] cannot write to mySQL database

2002-03-04 Thread Nicole Amashta
OK, go to your php.ini file and change your error_reporting level to this: error_reporting = E_ALL & ~E_NOTICE See if that at least yields different "error" or "warning" messages. Let me know what happens. Nicole www.aeontrek.com "Pilotdave" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PR

Re: [PHP-WIN] cannot write to mySQL database

2002-03-04 Thread pilotdave
"Nicole Amashta" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED].; > Could you post the code you are trying to use to do this? It may just be a > coding issue and not MySQL at all. > Sure. The database is called movies1db, username is movies, password is database. This definitely

Re: [PHP-WIN] cannot write to mySQL database

2002-03-04 Thread Nicole Amashta
#x27;Read Only' Look at the doc. > > A+ > > Alain > > > > > > -Original Message----- > > From: pilotdave [mailto:[EMAIL PROTECTED]] > > Sent: Saturday, March 02, 2002 5:06 PM > > To: [EMAIL PROTECTED] > > Subject: [PHP-WIN] cannot wr

RE: [PHP-WIN] cannot write to mySQL database

2002-03-02 Thread alain samoun
:[EMAIL PROTECTED]] Sent: Saturday, March 02, 2002 9:01 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-WIN] cannot write to mySQL database I don't think that's it. Here's more info if it helps... I can input data from the mysql command line, just not through web pages. I have tr

Re: [PHP-WIN] cannot write to mySQL database

2002-03-02 Thread pilotdave
ve Mysql set as 'Read Only' Look at the doc. > A+ > Alain > > > -Original Message- > From: pilotdave [mailto:[EMAIL PROTECTED]] > Sent: Saturday, March 02, 2002 5:06 PM > To: [EMAIL PROTECTED] > Subject: [PHP-WIN] cannot write to mySQL database > > >

RE: [PHP-WIN] cannot write to mySQL database

2002-03-02 Thread alain samoun
You probably have Mysql set as 'Read Only' Look at the doc. A+ Alain -Original Message- From: pilotdave [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 02, 2002 5:06 PM To: [EMAIL PROTECTED] Subject: [PHP-WIN] cannot write to mySQL database I am just setting up my first

[PHP-WIN] cannot write to mySQL database

2002-03-02 Thread pilotdave
I am just setting up my first php/mySQL/Apache website running on a win98 machine. I got it working so it can read data from the database, however it seems to be unable to write to the database. I can send queries to it. I am getting the feeling that its a problem with write permission somehow.