07032006 1818 GMT-6
I have this insert statement that Im working with and Im getting an
error that says...
"You have an error in you SQL syntax near 'Revere Street'.
That is the address. Oddly, it took off the numbers of the street.
Is inserting into a varchar thats 20 in size, more than enough.
$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 .=' )';
------------------------ Yahoo! Groups Sponsor --------------------~-->
See what's inside the new Yahoo! Groups email.
http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/HKFolB/TM
--------------------------------------------------------------------~->
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/
