Newbie .. difficulties with writing in a table

[iNviNciblE4ever]

// Tabelle
mysql_query("CREATE TABLE Frage1 (
Age INT ,
Geschlecht VARCHAR(30),
Schulabschluss VARCHAR(30),
ZurZeit VARCHAR(30),
UmAus VARCHAR(30)
) "

i wanna write in the table ...

$optsex = "m"

mysql_query ("INSERT INTO Frage1 (Age,Geschlecht) VALUES ($txtAlter,$optsex)"

why it doesn't work ?
if i try it without "Geschlecht" and "$optsex" it works ...

Best Regards thE_iNviNciblE

 

[r937]

you need to use single quotes around a character string value

INSERT INTO Frage1 (Age,Geschlecht)
VALUES ($txtAlter,'$optsex')

p.s. why varchar(30)?? why not just single character values like M and F (mann und frau) or M and W (männlich und weiblich)?

rudy

http://rudy.ca/