- jQuery looping only works on last row
- <?php
- $query = "SELECT item, description, price, imageData, status, username, item_id FROM items";
- $result = mysql_query($query) or die(mysql_error());
- $z=0;
- while($row = mysql_fetch_array($result))
- {
- //echo other columns here//
- echo "<td><div id=status$z></div></td>";
- ?>
- <script type=text/javascript>
- function updatestatus(itemnum)
- {
- var url="updatestatus.php?auc=<?php echo $row['item_id']; ?>";
- jQuery('#status' + itemnum).load(url);
- }
- setInterval("updatestatus(<? echo $z?>)", 1000);
- </script>
- <?
- $z++;
- }
- ?>
- <?php
- session_start();
- require_once("connect.php");
- $id = $_GET['auc'];
- $getstatus = mysql_query("SELECT status FROM items WHERE item_id = '$id' ");
- $row = mysql_fetch_array($getstatus);
- echo"$row[status]";
- ?>
- <?php
- $query = "SELECT item, description, price, imageData, status, username, item_id FROM items";
- $result = mysql_query($query) or die(mysql_error());
- $javascript = "";
- $z=0;
- while($row = mysql_fetch_array($result))
- {
- //echo other columns here//
- echo "<td><div id=status$z></div></td>";
- // build the javascript to be put in the function later over here...
- $javascript .= "jQuery('#status". $z ."').load('updatestatus.php?auc=". $row['item_id'] ."');";
- $z++;
- }
- ?>
- <script type=text/javascript>
- function updatestatus()
- {
- <?php echo $javascript; ?>
- }
- setInterval(updatestatus, 1000);
- </script>
- function updatestatus(numitems) {
- var url = "";
- var itemID = "";
- for (i = 1; i <= numitems; i++) {
- itemid = getElementById('#status'+numitems).getAttribute("itemID")
- url="updatestatus.php?auc="+itemID;
- jQuery('#status'+numitems).load(url);
- }
- }
- setInterval("updatestatus()", 1000);
- <div id="status1" itemid="23455">
- </div>