[RESOLVED] Calling table variables

NFClimber

I have a registration site that I am creating. I have a registrations page that installs variables into a 'users' table. Once they log in, I have a user_id variable that sets the session. I want to be able to print three static variables on another page (user_id, user_first, user_last) where users will enter additional information. I've tried using $_SESSION calls or using mysql_query("SELECT WHERE") statements...but nothing seems to pull the variables correctly...any ideas? 😕

bpat1434

Well, what does your code look like?

~Brett

NFClimber

Here is the code I'm using - the value, troop_num, is assisgned as the session variable.

$query = "SELECT troop_num, council_name, campsite_name FROM users WHERE troop_num='$_SESSION['troop_num']";

I keep getting an error while running this query...I finally figured out the right statement to call the variables I need, however I need it to only pull the variables if they belong to that specific session variable...make sense? heh..

Here's the error I'm getting...
Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\Inetpub\wwwroot\merit\roster.php on line 103

Thanks for the help!

bradgrafelman

Escape out of the string and concatenate the SESSION variable. Whenever you're referencing indeces in arrays and such, you should probably do this. For example, this would be a better method:

$query = "SELECT troop_num, council_name, campsite_name FROM `users` WHERE troop_num='" . $_SESSION['troop_num'] . "'";

Also note that you were missing an ending single quote in your SQL statment (which I added in my code snippet).

bpat1434

$query = "SELECT troop_num, council_name, campsite_name FROM users WHERE troop_num='$_SESSION['troop_num']";

Should be

$query = "SELECT troop_num, council_name, campsite_name FROM users WHERE troop_num='$_SESSION['troop_num']'";

You were missing the finishing single quote around the $_SESSION[] variable.

~Brett