sessions and mysql HELL

[maxsslade]

Hi,
I have a very weird problem, i havespent all of today trying to work it out bt i still dont have any luck. I am creating an intranet site and i want to display a list of personalised links for each user. I have everything sorted out using Sessions and Mysql as the database. But i have only one puzzling problem.

I can put the id number of the user in the userID field (which is 15) but if i put the variable which is associated with the sessions ($userID) it wont do anything. i have been fiddling with the code all day i hope you can help me.

Here the code i am having trouble with

dbConnect(cragpit);
$query=("SELECT * FROM links WHERE userID='$userID'");
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();

thanks, Max

[Anon]

Try doing an "echo var_dump($userID)" (without the quotes in your code) and seeing what the value of $userID would be.