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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
-------------------------------------------------------------------------------
Joe Stump, PHP Hacker, [EMAIL PROTECTED] -o)
http://www.miester.org http://www.care2.com /\\
"It's not enough to succeed. Everyone else must fail" -- Larry Ellison _\_V
-------------------------------------------------------------------------------
--
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]
