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
[EMAIL PROTECTED] wrote:
>
> Subject: RE: FIle Uploading to database
> Date: Mon, 4 Feb 2002 12:50:44 +1000
> From: "Adam Royle" <[EMAIL PROTECTED]>
> To: "Todd Williamsen" <[EMAIL PROTECTED]>, <[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!
>
> ------------------------------------------------------------------------
>
> Subject: Re: FIle Uploading to database
> Date: Sun, 3 Feb 2002 21:08:41 -0600
> From: "Todd Williamsen" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
>
> 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!
> >
> >
> >
>
> ------------------------------------------------------------------------
>
> Subject: Re: [PHP-DB] Re: FIle Uploading to database
> Date: Mon, 4 Feb 2002 07:54:14 -0600
> From: Dan Brunner <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> CC: [EMAIL PROTECTED]
>
> 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, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
> >
--
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.
============================================
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
