Log in Set Cookie if field = 1

Sorry MIke,

It works perfectly.

I must have been tired last night and made a simple mistake. Started afresh this morning, punched it all in again and bingo! it worked first time.

Thanks for help.

Cheers


Dave

Sorry Mike, that doesn't change anything. Still no-one can login.

Perhaps I should change tack, go back to the original login set up but put a kind of "IF active =1 redirect to new page" line at the top.

Do you think that would be more straight forward?

Dave

Try just using the value in the recordset like this:
$query_rsLogin = sprintf("SELECT dcc_user, dcc_password, FROM dcc_users WHERE dcc_user= '%s' AND dcc_password = '%s' AND active = 1",
$myUsername_rsLogin,$myPassword_rsLogin);

You can modify the code to work how you want, you might get a red exclamation mark in your server behaviors panel, but the code will work on the server. try using this code in place of your query. This examples needs a coulmn named dcc_active in your db, change to what ever your is named.

mysql_select_db($database_con_dcc, $con_dcc);

$active_UserValue = 0; // Use 1 if that equals an active user

$query_rsLogin = sprintf("SELECT dcc_user, dcc_password FROM dcc_users WHERE dcc_user= '%s' AND dcc_password = '%s' AND dcc_active = '%s'", $myUsername_rsLogin,$myPassword_rsLogin,$active_UserValue);