recordset from $_SESSION

i have a login page and authenicate user server behavior
last part sets session variable ['client_ID']

when the person logs in it redirects to correct page.

On that page i would like to display
Welcome (first name) (last name) on that page.

i set up a recordset

$var1_rs_client = "-1";
if (isset($_SESSION['client_ID'])) {
$var1_rs_client = (get_magic_quotes_gpc()) ? $_SESSION['client_ID'] : addslashes($_SESSION['client_ID']);
}
mysql_select_db($database_connauto, $connauto);
$query_rs_client = sprintf("SELECT * FROM client_info WHERE client_info.client_ID = %s", GetSQLValueString($var1_rs_client, "int"));
$rs_client = mysql_query($query_rs_client, $connauto) or die(mysql_error());
$row_rs_client = mysql_fetch_assoc($rs_client);
$totalRows_rs_client = mysql_num_rows($rs_client);

can't get the recordset to populate?

thanks for your help,
Jim B

whenever you use a session, always include the following code before referencing the session variable:

<?php if(!session_id()) session_start(); ?>

no need to use a recordset for this.


on the login page, double click the authenticate user server behavior. on the third step, select the First name and last name columns to be stored in session variables once the user name logs in, instead of the recordset, you can display the sessions that are created.

thanks Jason

one other question about Security Assist

on a single login form can i apply more that one authenticate user behavior with each behavior tied to a different db table?

yes, you would probably want to have different login forms for that though.

thanks for your help, Jason.

got the session working fine.

reason i want to have the 3 authenticates is i have 3 different types of people logging in, clients, reps and dealers, and i have their information in 3 different tables.
When each logs in i want them to go to 3 different pages.

Is there a different way i should be thinking about this?

No, not with your currant set up having them in three separate tables.

as always, thanks for your help

I ended up with 3 different forms and a separate security assist authenticate for each form and it works correctly.
I used a checkbox show/hide function to show the correct form when the person checks which checkbox reflects their status.