Re: [PHP-DB] INSERT problem--Need help urgently

2004-03-30 Thread Jason Wong
On Tuesday 30 March 2004 20:13, [EMAIL PROTECTED] wrote: > okay I have echoed $sql and before I did enter anything into the form, the > form is already inserting null values into the database. Maybe that is the > reason for the duplicate row of null values. Yes, that would be the reason. > Do yo

Re: [PHP-DB] INSERT problem--Need help urgently

2004-03-30 Thread irinchiang
Hi Jason: okay I have echoed $sql and before I did enter anything into the form, the form is already inserting null values into the database. Maybe that is the reason for the duplicate row of null values. Do you know how can I prevent this from happening??Hope to hear from you soon. Regards,

Re: [PHP-DB] INSERT problem--Need help urgently

2004-03-30 Thread Jason Wong
On Tuesday 30 March 2004 19:46, [EMAIL PROTECTED] wrote: > sorie it was my typo error. actually in my code there is already {} with my > first if statement and there is also a space after VALUES... Whenever you post code, use copy and paste, or be extremely meticulous that you do not introduce ty

Re: [PHP-DB] INSERT problem--Need help urgently

2004-03-30 Thread irinchiang
sorie it was my typo error. actually in my code there is already {} with my first if statement and there is also a space after VALUES... I still need some help here with my code...how can I prevent it from inserting a duplicate row of null values>??? Anyone can help ? Thanks in advance. Regard

[PHP-DB] INSERT problem--Need help urgently

2004-03-29 Thread irinchiang
Hi all: I was having some problem with INSERT query here and do hope to get some help real soon. I have a form whereby once the form is submitted, the values entered shall be inserted into the database. Next I have also written a SELECT query to view the records which have just been inserted i

Re: [PHP-DB] Insert problem

2003-08-14 Thread Kim Kohen
G'day All, Duh! Sorry, I had deleted the line that calls the query. I need to get home... cheers kim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Insert problem

2003-08-10 Thread Kim Kohen
G'day all, I have a problem with an insert which is proving infuriating. When I run the following code everything seems to work (no errors) except the database remains empty. When I echo $query and run it from a command line it inserts fine. I don't get any connection errors - in fact when I ech

RE: [PHP-DB] INSERT problem - please help!

2002-05-28 Thread Jen Swofford
Thanks everyone - it turns out that variables can not begin with a number, as someone else on this list learned today as well. Doh! :) Jen Swofford [EMAIL PROTECTED] > On Tuesday 28 May 2002 06:00, Jen Swofford wrote: > > I have a problem. I am working on two separate sites on two separate >

RE: [PHP-DB] INSERT problem - please help!

2002-05-27 Thread Jen Swofford
Sigh... they are set to On. Anything else anyone can think of? Jen > On Tuesday 28 May 2002 06:00, Jen Swofford wrote: > > I have a problem. I am working on two separate sites on two separate > > servers (one is Linux and one is Unix) and I am doing virtually the same > > thing with each, yet

Re: [PHP-DB] INSERT problem - please help!

2002-05-27 Thread Jason Wong
On Tuesday 28 May 2002 06:00, Jen Swofford wrote: > I have a problem. I am working on two separate sites on two separate > servers (one is Linux and one is Unix) and I am doing virtually the same > thing with each, yet only one of them works. What can I be doing wrong? Check your php.ini files.

[PHP-DB] INSERT problem - please help!

2002-05-27 Thread Jen Swofford
I have a problem. I am working on two separate sites on two separate servers (one is Linux and one is Unix) and I am doing virtually the same thing with each, yet only one of them works. What can I be doing wrong? It is a simple form. I simply want to put information into a database. This is w

Re: [PHP-DB] INSERT Problem

2001-09-05 Thread Miles Thompson
Have a look at addslashes http://www.php.net/manual/en/function.addslashes.php Miles At 01:20 PM 9/5/01 +0200, shi wrote: >Hi >I'm trying to insert a text into a MYSQL DB, and here is the problem. If the >text looks like this "x xx x x xxx 'xxx xxx" then PHP interprets the >text following the

[PHP-DB] insert problem mysql

2001-09-05 Thread shi
Hi I'm trying to insert a text into a MYSQL DB, and here is the problem. If the text looks like this "x xx x x xxx 'xxx xxx" then PHP interprets the text following the ' as an sql statement. Does anyone know how to overcome this problem. Thank you Shimon -- PHP Database Mailing List (http

[PHP-DB] INSERT Problem

2001-09-05 Thread shi
Hi I'm trying to insert a text into a MYSQL DB, and here is the problem. If the text looks like this "x xx x x xxx 'xxx xxx" then PHP interprets the text following the ' as an sql statement. Does anyone know how to overcome this problem. Thank you Shimon -- PHP Database Mailing List (http

RE: [PHP-DB] INSERT Problem

2001-05-09 Thread Jeff Oien
That told me my problem. Thank you! I hadn't selected the database in my connect include but had it in other scripts and not this one. Long story but thanks for the help. I can stop banging my head now. Jeff Oien > on 5/9/01 12:29 PM, Jeff Oien at [EMAIL PROTECTED] wrote: > > > Am I missing some

RE: [PHP-DB] INSERT Problem

2001-05-09 Thread Jeff Oien
OK, did that and it's just printing the INSERT command back to me. INSERT INTO OVEvents (First_Name, Last_Name) VALUES("Jeff", "Oien") Any help from here? Thanks. Jeff Oien > > echo $sql; > > > always helpful, then paste that into the command line client and check the > error > > > Cameron

[PHP-DB] INSERT Problem

2001-05-09 Thread Jeff Oien
This is driving me nuts. I can't insert anything into a mysql database using PHP. I can insert from the command line when logged in with Telnet. Using PHP I can connect and retrieve data from the database, just can't INSERT anything. This is what doesn't work: $sql = "INSERT INTO $table_name (Fir