Re: [PHP-DB] Mysql not receiving the data

2004-06-13 Thread franciccio
Some of the reason to have "register_global" on is to easly use variables sent by post, get, cookie method of a form. Ex. in your code at the page "anypage.php" you will have available the variables: $get_var==1 and $text_post=="Hello World" if "register_global=TRUE "

Re: [PHP-DB] Mysql not receiving the data

2004-06-13 Thread Hans Lellelid
Hi Andrew, Andrew Rothwell wrote: Thank you everybody that responded so quickly - I used the suggestion of Franciccio - and the data is now gow into the db Thank you very much - I really appreciate the help. Another question - with this fix in place - do I still need the register_globals = On ? Or

RE: [PHP-DB] Mysql not receiving the data

2004-06-13 Thread Andrew Rothwell
you all again Andrew -Original Message- From: franciccio [mailto:[EMAIL PROTECTED] Sent: Sunday, June 13, 2004 12:26 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Mysql not receiving the data I agree, the slashes are killing the query. I would suggets doing this: $add = "INSERT

Re: [PHP-DB] Mysql not receiving the data

2004-06-13 Thread franciccio
='".addslashes($star2)."', > star3='".addslashes($star3)."', > brief_synopsis='".addslashes($brief_synopsis)."', > imdb_link='$imdb_link'"; > > Hope this helped. > Rich &g

RE: [PHP-DB] Mysql not receiving the data

2004-06-13 Thread Rich Hutchins
star3='".addslashes($star3)."', brief_synopsis='".addslashes($brief_synopsis)."', imdb_link='$imdb_link'"; Hope this helped. Rich -Original Message- From: Andrew Rothwell [mailto:[EMAIL PROTECTED] Sent: Sunday,

Re: [PHP-DB] Mysql not receiving the data

2004-06-13 Thread Lester Caine
Andrew Rothwell wrote: Hi Larry, Thank you very much for the very quick response, I set my php.ini file (located /etc/php.ini ) for the register_globals = On (it was off by default) Now however I get an error Error adding entry: You have an error in your SQL syntax near 's spanish driver is found

RE: [PHP-DB] Mysql not receiving the data

2004-06-13 Thread Andrew Rothwell
AM To: Andrew Rothwell Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Mysql not receiving the data > Online I could see everything, and the pages gave the appearance of > working, however when I went into the DB using PHPMYADMIN to check the > status of the new data entered, all I found wa

Re: [PHP-DB] Mysql not receiving the data

2004-06-13 Thread Larry E . Ullman
Online I could see everything, and the pages gave the appearance of working, however when I went into the DB using PHPMYADMIN to check the status of the new data entered, all I found was blank rows ( for the new data since the rebuild, all the old data was there) There were the correct number of