$result = mysql_query("
select CashID,something,something1,something2
from MsUser mu, MsCash mc
where mu.UserID = mc.UserID and (something2 = 1 or something2 = 2)");
while(($row = mysql_fetch_array($result) !== false)){
This doesn't works
}
CashID is in MsCash, UserID is in MsUser and MsCash. Why it doesn't work on PHP? It works when try to take only one table, but when its get joined, mysql_fetch_array return me an error.
$resultLog = mysql_query("
select UserID from MsUser where username=$username and password=$password
");
while(($row1 = mysql_fetch_array($resultLog) !== false)){
//This works
}
Warning: mysql_fetch_array() expects parameter 1 to be resource, null given ...
I have tried this in a blank page
<?
include "connect.php";
$result = mysql_query("
select CashID,something,something1,something2
from MsUser mu, MsCash mc
where mu.UserID = mc.UserID and (something2 = 1 or something2 = 2)");
if($result === false){
echo 'Query error: '.mysql_error();
}else{
echo "works";
}
?>
but it give me nothing, also the echo doesn't show too.
Thanks.