Advertisement
Guest User

Untitled

a guest
Aug 29th, 2014
249
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?php
  2. $r1=sql_query("SELECT * FROM `".$sql[0]['database']."`.`".$table['o_marques']."` WHERE corbeille='0' ORDER BY titre ASC",$sqlid[0]);
  3. $listMarque = "";
  4. while($row1=sql_fetch_array($r1)){
  5. //
  6. // Compter si article dispo
  7. $r2=sql_query("SELECT * FROM `".$sql[0]['database']."`.`".$table['o_articles']."` WHERE marque='".$row1['id']."' AND corbeille='0' AND active='1'",$sqlid[0]);
  8. $num2=sql_num_rows($r2);
  9. if($num2>0){
  10. $listMarque .= "<li><a href=\"/".$row1['rewrite'].".html\">".$row1['titre']."</a></li>";
  11. }
  12. }
  13. ?>
  14. <ul>
  15. <?php echo $listMarque; ?>
  16. </ul>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement