Hey did you get it to work yet?!?!
Dan On Sunday, February 3, 2002, at 09:08 PM, [EMAIL PROTECTED] wrote: > Umm.. > > SET parameter is for the UPDATE query > > > "Adam Royle" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... >> You missed the SET parameter in your query... example is below... >> >> $query = "INSERT INTO Canidate SET (FirstName, LastName, Indus... >> >> Adam >> >> -----Original Message----- >> From: Todd Williamsen [mailto:[EMAIL PROTECTED]] >> Sent: Monday, February 04, 2002 11:06 AM >> To: [EMAIL PROTECTED] >> Subject: Re: FIle Uploading to database >> >> >> Well... thanks to Dan Burner for the script... BUT >> >> I cannot get this friggin INSERT statement to execute.. which craps >> out.. >> I cannot figure it out. I have been staring at it for about an hour >> and I >> still cannot figure it out >> >> here it is: >> >> $db = @mysql_select_db($db_name, $connection) or die("Could not select >> database"); >> $query = "INSERT INTO Canidate(FirstName, LastName, Industry, Address1, >> Address2, City, State, Zip, LocationPref, Phone, Email, ResumeUp) >> VALUES >> ('$FirstName', '$LastName', '$Industry' '$Address1', 'Address2', >> '$City', >> '$State', '$Zip', '$LocationPref', '$Phone', '$Email', '$ResumeUp2')"; >> $result = @mysql_query($query, $connection) or die("could not execute >> query"); >> $pat = array("#", "@", "*", "&", "%", "@","$","'","`"); >> $w= '_'; >> $ResumeUp2 = str_replace ($pat, $w, stripslashes($ResumeUp)); >> exec("cp '$ResumeUp' '/resumes/$ResumeUp2'"); >> ?> >> >> it errors out on the $result "could not execute query" >> >> Let me know if you need more info! >> >> Thank you! >> >> >> > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
