ruary 23, 2001 17:21
> To: Clayton Dukes
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] Help INSERTing to MySQL
>
>
> Before your VALUES you need to have a list of the fields ie:
>
> insert into table (id,fname,lname) values ('$id','$fname','$ln
0 also works for AUTO_INCREMENT fields...
> -Original Message-
> From: Philip Olson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 23, 2001 18:41
> To: Clayton Dukes
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] Help INSERTing to MySQL
>
>
>
> > I
> If I knew I could get answers that easy here, I woudn't have worked on this
> for 20 hours :-)
>
> THANKS
>
> btw, field one is an ID field set to auto increment, how can I insert that
> if I don't know what it is?
In this case use NULL as the value for id and it'll auto increment nicely
Addressed to: Clayton Dukes <[EMAIL PROTECTED]>
[EMAIL PROTECTED]
** Reply to note from Philip Olson <[EMAIL PROTECTED]> Sat, 24 Feb 2001 01:31:30
+ (GMT)
>
>
> > Hello, This is my first attempt, so I'm prolly doing something stupid,
> > but can someone tell me why this doesn't
;),
> > date varchar(10),
> > subject varchar(200),
> > title varchar(200),
> > author varchar(200),
> > email varchar(50),
> > language
enum('English','Danish','Dutch','Finnish','German','Spanish
;Finnish','German','Spanish'),
> grade int(3),
> level enum('High School','College','Other'),
> city varchar(15),
> state varchar(15),
> county varchar(15),
> school varchar(45),
> zip smallint(5),
> authorc
um('High School','College','Other'),
city varchar(15),
state varchar(15),
county varchar(15),
school varchar(45),
zip smallint(5),
authorcomments varchar(200),
teachercomments varchar(200),
approve enum('Y','N'),
docdata text
> Hello, This is my first attempt, so I'm prolly doing something stupid,
> but can someone tell me why this doesn't work? All it returns is
> "Unable to INSERT to database"
Change : or die("Unable to INSERT to database");
To : or die(mysql_error());
And see what it tells you. Odds are ther
Before your VALUES you need to have a list of the fields ie:
insert into table (id,fname,lname) values ('$id','$fname','$lname')
--joe
On Fri, Feb 23, 2001 at 08:00:30PM -0500, Clayton Dukes wrote:
> Hello,
> This is my first attempt, so I'm prolly doing something stupid, but can someone tell
9 matches
Mail list logo
