Using variables from the URL

Hi,

I can pass a variable to a page in the URL but cannot use it in a mySQL query.

The variable passed is "id". Say it is equal to 3 so the url looks like .....sim.php?id=3

I can print this on a page. But as I say i cannot use it in a mySQL query:

"SELECT * FROM sim WHERE id = '$id'"

Do i need to do something with $HTTP_GET_VARS['id']?????????

Someone please help?

Thanks in advance,

Dave.

if id is a number you probably don't want the single quotes around it in your comparison...

I have tried that but it still doesn't work, any other suggestion.

Dave,

In the your table 'sim', do you have a column named 'id'? If you don't then this is your problem.

I do have a column called id??????????

maybe try this:
$sql = "SELECT * FROM sim WHERE id = '" . $id . "' ";

it might be actually printing $id instead of resolving it. try printing your SQL statement to the screen instead of the value of $id. =)

-nate