WML, PHP, MySQL

wxdqz

New Member
The following WML always returns no rows even though it should. The similar code works in non-WML and I'm stumped. If I remove the WHERE clause, it returns all rows.

Please, please help!!!

Chris

<?php
Header("Content-type: text/vnd.wap.wml");
Header("Cache-Control: no-cache, must-revalidate");
Header("Pragma: no-cache");
echo ("<?xml version='1.0'?>");
?>

<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">

<wml>
<card id="logmein" title="Logging in ...">
<p>
<?php
$LID=chop("$(loginid)");
$PWD=chop("$(password)");
echo "Checking $LID ...";
$db=mysql_pconnect("localhost","boothman","oq3Nnone");
mysql_select_db("atlanticdreams_com",$db);
$sql="SELECT UserNumber,UserID,Password,CompanyID,KnownAs FROM ez2_Users WHERE UserID like '%$LID%' AND Password like '%$PWD%'";
$result=@mysql_query($sql,$db);
$arows=mysql_affected_rows();
echo "<p>R1:$result</p>";
echo "<p>R2:$arows</p>";
if ($arows != 0) {
$myrow = mysql_fetch_row($result);
echo "<p><a href='http://www.phpbuilder.com/board/archive/index.php/Welcome.wml#Welcome'>Welcome ".$myrow[4]."</a></p>";
} else {
echo "<p>Failed ... <a href='http://www.phpbuilder.com/board/archive/index.php/LoginScreen.wml#LoginScreen'>Try Again</a></p>";
}
?>
</p>
</card>
</wml>
 
Back
Top