[SOLVED] Loop

[Zepo.]

If i want to loop a table but ignore the ones with the same id in anouther table how would i do that in one query? This is urgent so please post suggestions.

[Barand]

Use a LEFT JOIN and only print those where values from right table are null

[Zepo.]

Use a LEFT JOIN and only print those where values from right table are null

 

Can you give me an example of this please.

[Barand]

see

 

http://www.phpfreaks.com/tutorial/data-joins-unions/page4

[Zepo.]

Wow i got completely lost.

Can you please write an example that follows this

SELECT * FROM `mybb_offers` WHERE `cat` ='".$cat."' AND `MID` = 'no'  ORDER BY `".$orderby."` ".$order." LIMIT $page,10

But where it doesn't pull if ID exists in table offerscompleted in the ID column .

[Barand]

$sql = "SELECT a.* 
          FROM `mybb_offers` a
              LEFT JOIN offerscompleted c ON a.ID = c.ID
          WHERE a.`cat` = '$cat' 
              AND `MID` = 'no' 
              AND c.ID IS NULL 
          ORDER BY a.`$orderby` $order 
          LIMIT $page,10";

 

[Zepo.]

$sql = "SELECT a.* 
          FROM `mybb_offers` a
              LEFT JOIN offerscompleted c ON a.ID = c.ID
          WHERE a.`cat` = '$cat' 
              AND `MID` = 'no' 
              AND c.ID IS NULL 
          ORDER BY a.`$orderby` $order 
          LIMIT $page,10";

 

Thank you so much sir.