Help setting session variable

[zenAngler2000]

I am trying to set a session variable for EmplID which should be pulled from the query below. I think that I'm doing it right but can someone tell me how to echo it correctly so I can see if it is setting the correct thing? The other two session variables that I set at the bottom seem to work fine. Thanks.

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

// Trying to create a session variable for the employeeID
$_SESSION['EMPID']=$result['EMPID'];

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");

[foyer]

did you try any troubleshooting?

try to echo $result['EMPID']; and tell me if you see any results then go from there.

(hint you aren't going to see any results)

so this is not a session issue but another issue in your code.

[bradgrafelman]

As foyer hinted at, [man]mysql_query/man doesn't return any data from SQL - it simply executes the query and returns a resource.

What you need to do is retrieve a row from the result set, e.g. using [man]mysql_fetch_assoc/man.

Also note that using [man]session_register/man has been deprecated for some time now and that you should simply stick to using the $_SESSION array.

[zenAngler2000]

Based on your suggestions, I researched it, came up with this:

// Register the EmployeeID which is part of the result set
$row = mysql_fetch_array($result);
$_SESSION['sEMPLID']=$row['EMPLID'];

and now it works fine. Thanks for the point in the right direction.

[bradgrafelman]

Don't forget to mark this thread resolved.