Inserting record into table. (newbie plz help)

[Tread42]

I'm new to mysql but can't get why the following code does not work? Please advise if I need to include more code for disection.

$usertable = "suggestion";

$sql= "INSERT INTO $usertable
VALUES ($name, $location, $phone, $support_improve, $suggestion, $benefit)";

mysql_query($sql) or die("query didn't work try again!"

Regards,
Tread42

 

[danielhozac]

What exactly doesn't work?

//Daniel

 

[namida]

you need quotes


$sql= "INSERT INTO $usertable
VALUES ('$name', '$location', '$phone', '$support_improve', '$suggestion', '$benefit')";

Regards,

Namida

 

[Tread42]

Thanks namida.
I did need the quotes. Plus it helped when I contacted my server admin and he informed me he changed the server name from 'www' to another name! It always helps. But even that wouldn't have worked without the quotes.

Regards,
Tread42