RE: FIle Uploading to database
| From: | Adam Royle | Date: | Mon, 04 Feb 2002 02:50:44 +0000 |
| Subject: | RE: FIle Uploading to database | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16474@lists.php.net to get a copy of this message | ||
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!