Re: 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 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)) { > 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>"; > } > } > ?> > > <h1>Submit a new document to the database</h1> > <form> > Email Address: <input type=text name=email><br> > Category: <select name=category><? print "$CATEGORIES" > ?></select><br> > Sub Category: <select name=subcategory><? print "$SUBCATEGORIES" > ?></select><br> > Date Document was written: <input type=text name=date> (xx-xx-xxxx)<br> > Document Subject: <input type=text name=subject><br> > Document Title: <input type=text name=title><br> > Document Author: <input type=text name=author><br> > Document Language: <input type=text name=language value=English><br> > Grade Received (Percentage): <input type=text name=grade size=3> > (xx/100)<br> > Grade Level of Paper: <select name=level><option>High > School</option><option>College</option><option>Other</option></select><br> > City in which paper was submitted: <input type=text name=city > value=Jacksonville><br> > State in which paper was submitted: <input type=text name=state > value=FL><br> > County in which paper was submitted: <input type=text name=county value=Duval> > <b>(County, not Country!)</b><br> > School at which paper was submitted: <input type=text name=school > value="Mandarin High School"><br> > ZIP code: <input type=text name=zip size=5 value=32257> <b>(Put your ZIP > code in if you don't know your school's)</b><br> > Author's Comments: <input type=text name=authors_comments><br> > Teacher's Comments: <input type=text name=teachers_comments><br> > Document (ASCII TEXT ONLY):<br> > <textarea name=docdata cols=80 rows=30>Paste document text here</textarea> > <p><input type=submit value="Submit for verification"> > </form> > > -----END----- > > > > TIA! > Clayton > > -- > 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 -- ------------------------------------------------------------------------------- Joe Stump, PHP Hacker, joestump98@yahoo.com -o) http://www.miester.org http://www.care2.com /\\ "It's not enough to succeed. Everyone else must fail" -- Larry Ellison _\_V -------------------------------------------------------------------------------