-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
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 -
-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
: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
]
cc:
Subject: Re: [PHP-DB] MySQL Returns
Error
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
- 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
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
-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
]
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
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
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
12 matches
Mail list logo