Query help...

[Anon]

PHP - 4.0.4 - Win Binaries with ISAPI
MySQL - 3.23.28-gamma
Server- PWS 5.0

What is the code required for checking a user/pass against a database? Does it involve something like

$mysql_query("SELECT * FROM a WHERE user=$user AND pass=$pass");

??

Thanks for any and all help.

EagleEyes

[Anon]

Personaly I've done like this...

This is my test Routine

---

$verifentry = "OK";

print("member value : $member <BR>\n");

if($login == "")
{
$verifentry = "Manque Login name !<BR>\n";
}
elseif($password == "")
{
$verifentry = "Manque Password !<BR>\n";
}

if($verifentry == "OK")
{
$errcont = 1; //Boolean de controle d'erreur

// Ouvrir la database avec un utilisateur "lecture seule"

$mysqllink = mysql_connect("MySQL", "Database", "Passwd");

// Traitement d'erreur d'ouverture...

$errno = mysql_errno($mysqllink);
$error = mysql_error($mysqllink);

if($errno <> 0)
{
	$errcont = 0;
	print ("Lors de la connection a SQL : Error $errno : $error<BR>\n");
	print ("Veuillez contacter le WEBMASTER par e-mail...<BR>\n");
}
else
{
	$mysqlselect = mysql_select_db("Table", $mysqllink);

	$errno = mysql_errno($mysqllink);
	$error = mysql_error($mysqllink);

	if ($errno <> 0)
	{
		$errcont = 0;
		print ("Lors du select DB : Error $errno : $errot<BR>\n");
		print ("Veuillez contacter le WEBMATER par e-mail...<BR>\n");
	}
}


//Si pas d'erreur, continuer, sinon GOTO fin

if($errcont == 1)
{
	// Compter le nombre d'element répondant au critere de selection
	//
	$query = "SELECT * FROM users where login_name like \"$login\"";

	$mysqlresult = mysql_query($query, $mysqllink);

	$nbrarg = mysql_affected_rows($mysqllink);

	//Donnees de controle, a supprimer de la version definitive !

	print("QUERY : $query  <BR>\n");
	print("Result : $mysqlresult <BR>\n");
	print("NBRARG : $nbrarg  <BR>\n");
	print("MYSQLLINK : $mysqllink <BR>\n");
	print("MYSQLSELECT : $mysqlselect <BR>\n");

	if($nbrarg = 0)
	{
		//Creer l'utilisateur
		print ("Utilisateur non reference ou reference plusieurs fois !<BR>\n");
	}
	elseif($nbrarg = 1)
	{
		$row = mysql_fetch_array($mysqlresult);
		$mysqlpswd = $row["password"];

		if($mysqlpswd == $password)
		{
			print("_Blank<BR>\n");
			print("$mysqlpswd = $password OK<BR>\n");
		}
		else
		{
			print("$mysqlpswd = $password NOT OK<BR>\n");
		}
	}
	else
	{
		print("Une erreur s'est produite, vous êtes référencé plusieurs<BR>\n");
		print("Veuillez contacter le webmaster par e-mail !");
	}

}
mysql_close($mysqllink);

}
else
{
print("$verifentry");
}
?>