[PHP] Help INSERTing to MySQL

2001-02-23 Thread Clayton Dukes
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" ---BEGIN--- ? $time = time(); $rand = Random_Password(5); $docid = $time . $rand; if (isset($email) isset($docid)) {

Re: [PHP] Help INSERTing to MySQL

2001-02-23 Thread Joe Stump
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

Re: [PHP] Help INSERTing to MySQL

2001-02-23 Thread Philip Olson
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

Re: [PHP] Help INSERTing to MySQL

2001-02-23 Thread Clayton Dukes
Friday, February 23, 2001 8:31 PM Subject: Re: [PHP] Help INSERTing to MySQL 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 INS

Re: [PHP] Help INSERTing to MySQL

2001-02-23 Thread Kyndig
(200), approve enum('Y','N'), docdata text, PRIMARY KEY (id), UNIQUE id (id) - Original Message - From: "Philip Olson" [EMAIL PROTECTED] To: "Clayton Dukes" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, February 23, 2001 8:31 PM Subject: Re:

Re: [PHP] Help INSERTing to MySQL

2001-02-23 Thread Clayton Dukes
Thanks! :-) Man, what a great list! You guys kick a$$ - Original Message - From: "Kyndig" [EMAIL PROTECTED] To: "Clayton Dukes" [EMAIL PROTECTED]; "Philip Olson" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, February 23, 2001 8:50 PM Subject: Re:

Re: [PHP] Help INSERTing to MySQL

2001-02-23 Thread php3
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 work?

Re: [PHP] Help INSERTing to MySQL

2001-02-23 Thread Philip Olson
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.

RE: [PHP] Help INSERTing to MySQL

2001-02-23 Thread ..s.c.o.t.t..
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 If I knew I could get answers that easy here

RE: [PHP] Help INSERTing to MySQL

2001-02-23 Thread ..s.c.o.t.t..
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','$lname') --joe On Fri, Feb 23, 2001 at 08:00:30PM -0500, Clayton Dukes wrote: Hello, This is my