Make sure the path name is correct....
Let's say you compiled apache with this prefix /web....
you must have the full path name to work...like this
exec("cp '$ResumeUp' '/web/htdocs/resumes/$ResumeUp2'");
Also check permissions...
I think that was my problem at first too!!!
You can also do debug the script.....
That should print the tmp file you form created.......
Let me know...
Once this pasts...It works really well...
On Monday, February 4, 2002, at 09:35 AM, [EMAIL PROTECTED] wrote:
> The INSERT statement works fine now, but the file isn't being uploaded.
> I cannot figure out why
> -----Original Message-----
> From: Dan Brunner [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 04, 2002 7:54 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Re: FIle Uploading to database
> Hey did you get it to work yet?!?!
> On Sunday, February 3, 2002, at 09:08 PM, [EMAIL PROTECTED] wrote:
>> 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...
>>> -----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
>>> 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
>>> $query = "INSERT INTO Canidate(FirstName, LastName, Industry,
>>> Address2, City, State, Zip, LocationPref, Phone, Email, ResumeUp)
>>> ('$FirstName', '$LastName', '$Industry' '$Address1', 'Address2',
>>> '$State', '$Zip', '$LocationPref', '$Phone', '$Email',
>>> $result = @mysql_query($query, $connection) or die("could not execute
>>> $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