[SOLVED] Inserting the value name instead of the actual value

[maddcow26]

This is my insert :

 

$query = "INSERT INTO formresults (qname, qemail, qaddress, burlap, gender, primarystyle, yearsprimary, yearsgrappling, weekly, stephanquestion, visitorsince, dvdpurchase) VALUES ('qname', 'qemail', 'qaddress', 'burlap', 'gender', 'primarystyle', 'yearsprimary', 'yearsgrappling', 'weekly', 'stephanquestion', 'visitorsince', 'dvdpurchase')";

 

 

It inserts to the database but it is inserting the value names (ie, qname) instead of the actual value (field name) passed from the form.

 

How do I fix this?

 

thanks in advance

 

 

[thesaleboat]

mysql_query("INSERT INTO `users_subcategories` (`username`, `SubCategoryId`) VALUES ('$myusername','$subcategory');") or die(mysql_error());

 

Here is what i use, you have to use the $ sign

[maddcow26]

Beautiful.

thanks buddy