Re: File Uploading to database

hi, straying from technical solutions, have you checked for any spelling error? looking at what you pasted in the mailing list, you have: $query = "INSERT INTO Canidate" shouldn't Canidate be Candidate instead? then... VALUES ('$FirstName', '$LastName', '$Industry' '$Address1', 'Address2', '$City', '$State', '$Zip', '$LocationPref', '$Phone', '$Email', '$ResumeUp2')"; does not have a comma between '$Industry' and '$Address1'. well this is with the assumption that you pasted what you are exactly trying to execute. there may be other tiny spelling or punctuation errors. hth, ric php-db-digest-help@lists.php.net wrote: > > Subject: RE: FIle Uploading to database > Date: Mon, 4 Feb 2002 12:50:44 +1000 > From: "Adam Royle" <adam@bigbridge.com.au> > To: "Todd Williamsen" <todd@williamsen.net>, <php-db@lists.php.net> > > 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:todd@williamsen.net] > Sent: Monday, February 04, 2002 11:06 AM > To: php-db@lists.php.net > 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! > > ------------------------------------------------------------------------ > > Subject: Re: FIle Uploading to database > Date: Sun, 3 Feb 2002 21:08:41 -0600 > From: "Todd Williamsen" <todd@williamsen.net> > To: php-db@lists.php.net > > Umm.. > > SET parameter is for the UPDATE query > > "Adam Royle" <adam@bigbridge.com.au> wrote in message > news:NFBBLNHECLCHINBOIGAEMEGICAAA.adam@bigbridge.com.au... > > 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:todd@williamsen.net] > > Sent: Monday, February 04, 2002 11:06 AM > > To: php-db@lists.php.net > > 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! > > > > > > > > ------------------------------------------------------------------------ > > Subject: Re: [PHP-DB] Re: FIle Uploading to database > Date: Mon, 4 Feb 2002 07:54:14 -0600 > From: Dan Brunner <daniel.brunner@desteracs.com> > To: todd@williamsen.net > CC: php-db@lists.php.net > > Hey did you get it to work yet?!?! > > Dan > > On Sunday, February 3, 2002, at 09:08 PM, todd@williamsen.net wrote: > > > Umm.. > > > > SET parameter is for the UPDATE query > > > > > > "Adam Royle" <adam@bigbridge.com.au> wrote in message > > news:NFBBLNHECLCHINBOIGAEMEGICAAA.adam@bigbridge.com.au... > >> 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:todd@williamsen.net] > >> Sent: Monday, February 04, 2002 11:06 AM > >> To: php-db@lists.php.net > >> 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, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > -- Ric Mañalac Head, Web Applications Dept. Web Philippines, Inc. ============================================ Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ============================================