Drop Menu Based on User Login

[bjblackmore]

Hi
How would I go about creating a dropdown menu from the user login? I have 2 tables

table1 = user_id, user_name, password
table2 = user_id, menu_option, menu_value

In the login script there is,

$sUserID = $row["user_id"];
session_register("sUserID");

And then at the start of the next page I have

session_start();

How do I call back the sUserID, and build a drop menu, based on table 2?
Many Thanks
Ben

[Anon]

If you've registered and started your session on the second page, then just access the variable...

SELECT menu_option, menu_value FROM table2 where user_id = '$sUserID'

I guess I don't understand your question completely....