Select Count Error?

[Zepo.]

This seems to completely ignore the left join.

$total=mysql_query("SELECT COUNT(*) 
 FROM `mybb_offers` a
              LEFT JOIN mybb_offerscompleted c ON a.ID = c.ID AND userid='$user_row[uid]'
          WHERE a.`cat` = '$cat' 
              AND `MID` = 'no' 
              AND c.ID IS NULL ");
$total=mysql_fetch_array($total);
$total="$total[0]";

[genericnumber1]

$total=mysql_query("SELECT COUNT(*) 
 FROM `mybb_offers` a
              LEFT JOIN mybb_offerscompleted c ON a.ID = c.ID AND userid='$user_row[uid]'
          WHERE a.`cat` = '$cat' 
              AND `MID` = 'no' 
              AND c.ID IS NULL ") 
                    or die(mysql_error()); // <----- add me!

[Zepo.]

It does not display any errors.

[lemmin]

I don't think your data is what you are expecting, based on that query. Try putting the "userid='$user_row[uid]'" part in the WHERE clause.

[Zepo.]

Well the thing is it works on a loop i have on anouther page. What i'm trying to do is leave out all the entrees with the id that matches the id in anouther table with the same userid.

[ainoy31]

wouldn't you need to use an alias for the userid and MID as well?

[Zepo.]

wouldn't you need to use an alias for the userid and MID as well?

I don't believe so.

[Zepo.]

Anyone?