Public paste
Arie
By: Xmoo | Date: Oct 8 2008 20:49 | Format: PHP | Expires: never | Size: 1.28 KB | Hits: 966

  1. <?php $obj=mysql_query("SELECT id FROM bloem_actie WHERE product = '1' ORDER BY RAND() LIMIT 1") or die(mysql_error());
  2.                 while($info= mysql_fetch_object($obj))      
  3.                 {
  4.                         $aid = $info->id;
  5. echo "<center><h2>The Winning ID for product 1 is: <a href="?p=actie&a=user&id=".$aid."">".$aid."</a></h2></center>";                  
  6.  }
  7. ?>
  8. <?php $obj=mysql_query("SELECT id FROM bloem_actie WHERE product = '2' ORDER BY RAND() LIMIT 1") or die(mysql_error());
  9.                 while($info= mysql_fetch_object($obj))      
  10.                 {
  11.                         $aid = $info->id;
  12. echo "<center><h2>The Winning ID for product 2 is <a href="?p=actie&a=user&id=".$aid."">".$aid."</a></h2></center>";                   
  13.  }
  14. ?>
  15. <?php $obj=mysql_query("SELECT id FROM bloem_actie WHERE product = '3' ORDER BY RAND() LIMIT 1") or die(mysql_error());
  16.                 while($info= mysql_fetch_object($obj))      
  17.                 {
  18.                         $aid = $info->id;
  19. echo "<center><h2>The Winning ID for product 3 is <a href="?p=actie&a=user&id=".$aid."">".$aid."</a></h2></center>";                   
  20.  }
  21. ?>
  22. <?php $obj=mysql_query("SELECT id FROM bloem_actie WHERE product = '4' ORDER BY RAND() LIMIT 1") or die(mysql_error());
  23.                 while($info= mysql_fetch_object($obj))      
  24.                 {
  25.                         $aid = $info->id;
  26. echo "<center><h2>The Winning ID for product 4 is <a href="?p=actie&a=user&id=".$aid."">".$aid."</a></h2></center>";                   
  27.  }
  28. ?>