Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 7th, 2012  |  syntax: None  |  size: 1.93 KB  |  hits: 15  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. jQuery looping only works on last row
  2. <?php
  3.  
  4. $query = "SELECT item, description, price, imageData, status, username, item_id FROM items";
  5. $result = mysql_query($query) or die(mysql_error());
  6.  
  7. $z=0;
  8. while($row = mysql_fetch_array($result))
  9. {  
  10.     //echo other columns here//
  11.     echo "<td><div id=status$z></div></td>";
  12.  
  13.     ?>
  14.  
  15.     <script type=text/javascript>
  16.         function updatestatus(itemnum)
  17.         {
  18.             var url="updatestatus.php?auc=<?php echo $row['item_id']; ?>";
  19.             jQuery('#status' + itemnum).load(url);  
  20.         }
  21.  
  22.         setInterval("updatestatus(<? echo $z?>)", 1000);
  23.     </script>
  24.  
  25.     <?  
  26.  
  27.     $z++;
  28.  
  29. }
  30.  
  31. ?>
  32.        
  33. <?php
  34.  
  35.     session_start();
  36.     require_once("connect.php");
  37.  
  38.     $id = $_GET['auc'];
  39.     $getstatus = mysql_query("SELECT status FROM items WHERE item_id = '$id'  ");
  40.     $row = mysql_fetch_array($getstatus);
  41.  
  42.     echo"$row[status]";
  43.  
  44. ?>
  45.        
  46. <?php
  47.  
  48.     $query = "SELECT item, description, price, imageData, status, username, item_id FROM items";
  49.     $result = mysql_query($query) or die(mysql_error());
  50.  
  51.     $javascript = "";
  52.     $z=0;
  53.  
  54.     while($row = mysql_fetch_array($result))
  55.     {
  56.  
  57.         //echo other columns here//
  58.         echo "<td><div id=status$z></div></td>";
  59.  
  60.         // build the javascript to be put in the function later over here...
  61.         $javascript .= "jQuery('#status". $z ."').load('updatestatus.php?auc=". $row['item_id'] ."');";
  62.  
  63.         $z++;
  64.  
  65.     }
  66.  
  67. ?>
  68.        
  69. <script type=text/javascript>
  70.  
  71.     function updatestatus()
  72.     {
  73.         <?php echo $javascript; ?>
  74.     }
  75.  
  76.     setInterval(updatestatus, 1000);
  77.  
  78. </script>
  79.        
  80. function updatestatus(numitems) {
  81.     var url = "";
  82.     var itemID = "";
  83.     for (i = 1; i <= numitems; i++) {
  84.         itemid = getElementById('#status'+numitems).getAttribute("itemID")
  85.         url="updatestatus.php?auc="+itemID;
  86.         jQuery('#status'+numitems).load(url);    
  87.     }
  88.  }
  89.  
  90. setInterval("updatestatus()", 1000);
  91.        
  92. <div id="status1" itemid="23455">
  93. </div>