Oh, and the error before then was becuase you had not put quotes
around the values in your query, not just the whole query; i.e., ...
"VALUES ('Bob', 'Smith', '123 On Some Street'"...
On 06/07/06, Phill Sparks <[EMAIL PROTECTED]> wrote:
> There's a comma (,) after phhome and again after the phone number.
> this is the cause of the error. There should be another field, or no
> comma.
>
> On 06/07/06, Wade Smart <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> >
> >
> >
> > 07052006 1845 GMT-6
> >
> > Im still having a bit of a problem with this insert.
> >
> > Im using the double quotes but this is the error:
> >
> > Players(fname,lname,address,city,state,zip,phhome,)
> > VALUES (Bob,Smith,123 On Some Street, Batesville, OG, 01235, 333-222-1111,)
> > Insert error: "You have an error in your SQL syntax.
> > Check the manual that corresponds to your MySQL server version for the
> > right syntax to use near
> > ')VALUES (Bob,Smith,123 On Some Street, Batesville, OG, 01"
> >
> > Thats all it gives. It just stops though.
> >
> > wade
> >
> >
> > On Mon, 2006-07-03 at 19:47 -0500, Mike Brandonisio wrote:
> > > Hi,
> > >
> > > You need to encapsulate your data in quotes. I would have done it
> > > like this with double quotes, single quote passed to query.
> > >
> > > $query = "INSERT INTO Players (fname, lname, address, city, state,
> > > zip, phhome, phcell, phwork, other, email)";
> > > $query .="VALUES (';
> > > $query .=" '".$_POST['fname']."', '".$_POST['lname']."', '".$_POST
> > > ['address']."',";
> > > $query .=" '".$_POST['city']."', '".$_POST['state']."', '".$_POST
> > > ['zip']."',";
> > > $query .=' '".$_POST['phhome']."', '".$_POST['phcell']."',";
> > > $query .=" '".$_POST['phwork']."', '".$_POST['other']."', '".$_POST
> > > ['email']."' ";
> > > $query .=" )";
> > >
> > > Sincerely,
> > > Mike
> >
> >
> >
> >
> >
>
Community email addresses:
Post message: php-list@yahoogroups.com
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
