Well sheesh,
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?
Here are the fields:
CREATE TABLE documents (
id bigint(20) DEFAULT '0' NOT NULL auto_increment,
docid varchar(20),
category enum('Language Arts','Sciences','Humanities','Arts','Special
Subjects','Other'),
subcategory enum('Physics','Biology','Chemistry','Math','Computers and
Internet','History','Economics','Geography','Law','Religion','Philosophy','B
lack Awareness','Countries','Drugs','Education','Environmental
Awareness','Politics','Health','Sex and Sexuality','Female
Awareness','Art','Movies or TV','Music','Sports','Charles
Dickens','Shakespeare','Biography','Fictional
Stories','Astronomy','Mythology'),
date varchar(10),
subject varchar(200),
title varchar(200),
author varchar(200),
email varchar(50),
language enum('English','Danish','Dutch','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),
authorcomments varchar(200),
teachercomments varchar(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: [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 INSERT to database");
> To : or die(mysql_error());
>
> And see what it tells you. Odds are there's a field not being accounted
> for. When not designating columns (just values) it's important to make
> sure all columns are accounted for. See :
>
> http://www.sqlcourse.com/
>
> It'll provide some basic SQL help. It's recommended to write out columns
> and values (easier to make sense of).
>
>
> Regards,
>
> Philip Olson
> http://www.cornado.com/
>
> >
> >
> > ---BEGIN---
> > <?
> > $time = time();
> > $rand = Random_Password(5);
> > $docid = $time . $rand;
> >
> > if (isset($email) && isset($docid)) {
> > mysql_connect("$HOSTNAME", "$DB_USER", "$DB_PASS");
> >
> > $query = "INSERT INTO documents VALUES ('$docid', '$category',
> > '$subcategory', '$date', '$subject', '$title', '$author', '$email',
> > '$language', '$gr ade', '$level', '$city', '$state', '$county',
> > '$zip', '$authors_comments', '$teachers_comments', 'N', '$docdata')";
> >
> > $result = mysql_db_query("$DATABASE", $query) or die("Unable to
> > INSERT to database");
> >
> > if ($result) {
> > echo "<p>$docid was added to the database</p>";
> > }
> > }
> > ?>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
