login problem

KND

well, for some reason when an admin with a client id of 1 logs in everything works perfectly. as someone with a client id other then 1 logs in they are not able to proceed. i have stared at this for about an hour and would GREATLY apprieciate any help anyone may be able to offer.

<?
include("inc/config.php");
$conn = mssql_connect($hostname, $user, $pass) or die('Error: MSSQL connection');
$query = "SELECT * FROM clients WHERE clientid = '$clientid' AND password = PASSWORD('$password')";
$result = mssql_query($database, $query, $connection);

if (num_rows($result) == 1)
	{
	session_start();

session_register("client_id");
session_register("client_name");

list($clientid, $name) = fetch_row($result);
$client_id = $clientid;
$client_name = $name;

header("Location: hollywood.php");
free_result ($result);

mssql_close($conn);
}
else

{
free_result ($result);	
mssql_close($conn);

header("Location: relogin.php");
exit;
}
?>

LordShryku

What's the error?

KND

they are sent to relogin.

LordShryku

Do you have these as custom functions?

num_rows (should be mssql_num_rows)
fetch_row (should be mssql_fetch_row)
free_result (should be mssql_free_result)

KND

ah well thank you. no, actually i'm not too familiar with mssql and this was my meager attempt to convert mysql to mssql. to make sure no conversion problems conflict with login problems here is the mysql script. (but thank you for that input because that may have saved me quite a bit of time in the future :p)

<?
include("inc/config.php");
$connection = mysql_connect($hostname, $user, $pass) or die ("Unable to connect!");
$query = "SELECT * FROM clients WHERE clientid = '$clientid' AND password = PASSWORD('$password')";
$result = mysql_db_query($database, $query, $connection);

if (mysql_num_rows($result) > 0)
	{
	session_start();

session_register("client_id");
session_register("client_name");

list($clientid, $name) = mysql_fetch_row($result);
$client_id = $clientid;
$client_name = $name;

header("Location: hollywood.php");
mysql_free_result ($result);

mysql_close($connection);
}
else

{
mysql_free_result ($result);	
mysql_close($connection);

header("Location: relogin.php");
exit;
}
?>

LordShryku

I'm not a fan of mssql, but you can check out all the functions here. Try replacing those and seeing if that helps...

KND

well that's not really the problem. the mysql login isn't working either...if there's scripting problems with that then i'm certainly not aware of it. with the mssql version i can certainly understand why there's errors :p

LordShryku

Oh, okay. So, lets setup for debugging. At the top of the script put this line

error_reporting(E_ALL);

And change

$result = mysql_db_query($database, $query, $connection);
//to 
$result = mysql_db_query($database, $query, $connection) or die(mysql_error());

And change the header redirect statements to

echo $query."<br><br>Rows: ".mysql_num_rows($result);

If there's an error, that should help you find it. For the SQL queries that are echoed, run them against the database also to make sure that they are right...

KND

ok, for sure, thanks. looks like i should be able to work off that.