RE: MySQL Returns Error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



UNIQUE gradient (gradient)

This is causing your issue. You have stated that new records cannot
match an already established record with the same name under gradient.

HTH

Aaron

-----Original Message-----
From: Jeff [mailto:jroth1@telus.net] 
Sent: August 5, 2003 1:44 PM
To: php-db@lists.php.net
Subject: Re:  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(10) NOT NULL,
date DATE DEFAULT '0000-00-00' NOT NULL,
well VARCHAR(50) NOT NULL,
field VARCHAR(25) NOT NULL,
uni VARCHAR(30) NOT NULL,
license VARCHAR(10) BINARY NOT NULL,
formation VARCHAR(20) NOT NULL,
perfs VARCHAR(20) NOT NULL,
event VARCHAR(1) NOT NULL,
fluid VARCHAR(2) NOT NULL,
mode VARCHAR(2) NOT NULL,
type VARCHAR(2) NOT NULL,
vhd VARCHAR(10) NOT NULL,
file VARCHAR(15) NOT NULL,
kb VARCHAR(6) NOT NULL,
grd VARCHAR(10) NOT NULL,
open VARCHAR(1) NOT NULL,
sour  VARCHAR(1) NOT NULL,
tube VARCHAR(10) NOT NULL,
landed VARCHAR(6) NOT NULL,
casing  VARCHAR(6) NOT NULL,
landed2 VARCHAR(6) NOT NULL,
shut_date VARCHAR(10) NOT NULL,
shut_time DATE DEFAULT '0000-00-00' NOT NULL,
pres VARCHAR(15) NOT NULL,
tag VARCHAR(15) NOT NULL,
PRIMARY KEY (lsd),
UNIQUE gradient (gradient)
);

"Jason Wong" <php-db@gremlins.biz> wrote in message
200308060128.12200.php-db@gremlins.biz">news:200308060128.12200.php-db@gremlins.biz...
> 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 -> www.gremlins.biz
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications Development
*
> ------------------------------------------
> Search the list archives before you post
> http://marc.theaimsgroup.com/?l=php-db
> ------------------------------------------
> /*
> Byte your tongue.
> */
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux