Re: [php-list] Mysql Insert Problem

2006-07-03 Thread Mike Brandonisio
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'].

[php-list] Mysql Insert Problem

2006-07-03 Thread Wade Smart
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.