Re: Help INSERTing to MySQL

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" <philip@cornado.com> To: "Clayton Dukes" <cdukes@cdukes.com> Cc: <php-general@lists.php.net> 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: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net