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: [email protected]
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/
