is this a valid query?

[Heywood]

I am stumped. Basically, I have an html form that uses a script to take those variables entered in the form, and put them into a table. This is extremely simple, and something I have done easily before, but this time, I am getting a weird error. Is this correct?

$sql = 'INSERT INTO main (id,name,url,suburl,recip) VALUES (\' $id \', \' $name \', \' $url \', \' $suburl \', \' $recip \')';

This should submit the variables from my form into the table. Instead it strores the variable name, as if it were a string.

here is what the entries in my table look like:

id name url suburl recip

1 $name $url $suburl $recip

2 $name $url $suburl $recip

Does anyone know what I am doing wrong here?

[nnichols]

You must remember to check quoting sequences to make sure they are escaped properly where necessary -

$sql = "INSERT INTO main (id,name,url,suburl,recip) VALUES ('$id', '$name', '$url', '$suburl', '$recip')";

or

$sql = 'INSERT INTO main (id,name,url,suburl,recip) VALUES ("' . $id . '", "' . $name . '", "' . $url . '", "' . $suburl . '", "' . $recip . '")';

Hope this helps