Simple MySQL INSERT

[aaron_karp]

I'm stumped. The variable $success keeps returning false. Any ideas?

$query = "INSERT INTO Members SET
contact_name = '$name',
contact_email = '$email',
company = '$company',
contact_relationship = '$relationship',
contact_phone = '$phone',
business_a1 = '$a1',
business_a2 = '$a2',
business_city = '$city',
business_state = '$state',
business_zip = '$zip',
business_url = '$URL',
business_type = '$biztype',
business_description = '$bigdescription',
paypal_email = '$paypalname1',
directory_title = '$listtitle',
directory_description = '$smalldescription',
membership_type = '$memtype',
membership_status = pending_approval ";
$success = mysql_query($query);

All values ($name, $company) etc. hold values. The database is set up with a Members table with these 18 fields and 1 auto incremented ID field. With the exception of the ID field, all fields are have the type 'text'

I thought I new this stuff, but I really can't figure this out. Please help!

[planetsim]

You are doing it wrong

a MySQL Insert looks something like this

"INSERT INTO tbl_name (id,name,age) VALUES('null','Paul','1')"

Unless you are trying to do an Update

[aaron_karp]

Now, it feels pretty wrong to disagree with someone who's posted more than 1100 times, but I'm pretty sure my ways works also, even if it's the third option in the MySQL manuel. I find it simpler for inserting larger sets of values because I can watch them match up better. Maybe it's something with the configuration of my database...

http://www.mysql.com/doc/en/INSERT.html

[planetsim]

Try mysql_error() on the query to see what the error gives. Im not sure your DB can handle that kinda query.

[aaron_karp]

That helped so much! I got the result "Unknown column 'pending_approval' in 'field list' " so I tried enclosing "approval_pending" in quotes. Now it works perfectly. Thanks!