What does mysql_query() return? Did you try checking mysql_error()? In
order to debug it, a good start would be removing the @ marks from your
MySQL statements, so that if there are any errors, you'd see them.
Zeev
At 17:12 12/4/2001, Joshua Butcher wrote:
I am using code that used to work... I am trying to connect to a database to
validate a logon. I get a user ID and password from an HTML file, passed to
my PHP script. It fetches the query, but it always returns 1, even if I pass
a password that is invalid. The query does not get returned to PHP properly.
I had PHP spit out the SQL string it uses and I pasted it into my MySQL
administrator and executed it to perfection.
I also checked my mysqld.log file and noted that mySQL is in fact executing
the query properly when PHP asks it to, and it is executing the proper
query, PHP just does not get the proper data back. I know the SQL server is
fine, because other databases work, and even other PHP code works, but this
snippet won't.
I can connect to the CANNON datasbase through Microsoft Access and myODBC,
so the data is fine.
Any assistance would be greatly appreciated.
//CODE BELOW
$DB_NAME="CANNON";
$muid="userid";
$mpwd="password";
$server="192.168.1.4";
$DBConn=mysql_connect($server,$muid,$mpwd);
echo "br[$DBConn]br";
@mysql_select_db("CANNON",$DBConn) || DIE("Cannot select Database X");
$uid = $HTTP_POST_VARS["userid"];
$pwd = $HTTP_POST_VARS["password"];
$strSQL="Select UserID,Password From Users Where Active0 AND UserID='$uid'
AND Password='$pwd'";
$result = @mysql_query("Select * From Users") || DIE ("brbCould not
query database.../b");
$count=@mysql_num_rows($result) || DIE("Could not count records in
recordset"); //ERROR HERE
if ($count == 0)
{
$FinalTag="META HTTP-EQUIV=\"REFRESH\" CONTENT=\"0;URL=login.htm\"";
$x=0;
}
else
{
$FinalTag="META HTTP-EQUIV=\"REFRESH\" CONTENT=\"0;URL=test.php\"";
$x=1;
}
if ($x==1)
{
setcookie("PBMGUID",$uid,time()+3600);
setcookie("PBMGPWD",$pwd,time()+3600);
}
echo $FinalTag;
//echo $FinalTag;
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
Zeev Suraski [EMAIL PROTECTED]
CTO co-founder, Zend Technologies Ltd. http://www.zend.com/
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
