RE: [PHP-DB] MySQL Returns Error

2003-08-14 Thread Matt Schroebel
-Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 3:52 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Returns Error Oops, my mistake, it's not a blank entry - it re enters the last entry. I can hit F5 or click refresh 1000 times

Re: [PHP-DB] MySQL Returns Error

2003-08-14 Thread Jason Wong
On Wednesday 06 August 2003 01:14, Jeff wrote: Well I did what you said, and now I get Parse error: parse error, unexpected T_ECHO in C:\FoxServ\www\encana_db.php on line 44 Try: $result = mysql_query($query, $link_id) OR die(mysql_error()); -- Jason Wong - Gremlins Associates -

RE: [PHP-DB] MySQL Returns Error

2003-08-14 Thread Matt Schroebel
-Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 3:15 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Returns Error Every time I access or refresh the page, it adds one blank entry to the DB. Maybe I have the insert query

RE: [PHP-DB] MySQL Returns Error

2003-08-14 Thread Hutchins, Richard
:52 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Returns Error Oops, my mistake, it's not a blank entry - it re enters the last entry. I can hit F5 or click refresh 1000 times and it will enter the last entry 1000 times. Jeff [EMAIL PROTECTED] wrote in message news

Re: [PHP-DB] MySQL Returns Error

2003-08-14 Thread jeffrey_n_Dyke
] cc: Subject: Re: [PHP-DB] MySQL Returns Error

Re: [PHP-DB] MySQL Returns Error

2003-08-14 Thread Jeff
To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Returns Error Every time I access or refresh the page, it adds one blank entry to the DB. Maybe I have the insert query in the wrong place? if ('POST' == $_SERVER['REQUEST_METHOD']) { //someone submitted the form with method=post // so validate input

Re: [PHP-DB] MySQL Returns Error

2003-08-14 Thread Jeff
- is there somewhere special I need to put that? Matt Schroebel [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 3:15 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Returns Error

Re: [PHP-DB] MySQL Returns Error

2003-08-14 Thread Jeff
this. This is how I have handled it in the past though. -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 3:52 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Returns Error Oops, my mistake, it's not a blank entry - it re enters the last

RE: [PHP-DB] MySQL Returns Error

2003-08-10 Thread Matt Schroebel
-Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 12:59 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL Returns Error Been working on this code all weekend, and I did take everyone's advice, but I'm still getting the same error. Error

RE: [PHP-DB] MySQL Returns Error

2003-08-05 Thread Aaron Wolski
] Subject: Re: [PHP-DB] MySQL Returns Error Ok, that worked, Now the error I'm getting is Duplicate entry ' ' for key 1 Is this a SQL table error? Here's my Table as entered: CREATE TABLE gradients ( gradient MEDIUMINT(10) DEFAULT '0' NOT NULL AUTO_INCREMENT, kwo VARCHAR(10) NOT NULL, lsd VARCHAR

RE: [PHP-DB] MySQL Returns Error

2003-08-05 Thread Matt Schroebel
Change the gradient definition to: gradient MEDIUMINT(10) NOT NULL AUTO_INCREMENT, -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 1:44 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Returns Error Ok, that worked, Now the error

Re: [PHP-DB] MySQL Returns Error

2003-08-05 Thread Jeff
Ok, that worked, Now the error I'm getting is Duplicate entry ' ' for key 1 Is this a SQL table error? Here's my Table as entered: CREATE TABLE gradients ( gradient MEDIUMINT(10) DEFAULT '0' NOT NULL AUTO_INCREMENT, kwo VARCHAR(10) NOT NULL, lsd VARCHAR(10) NOT NULL, date DATE DEFAULT