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.

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

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 you

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

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 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.

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 only

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 ' as

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 HINT echo $sql; /HINT always helpful, then paste that into the command line client and check the error Cameron

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