Public feed
#379418
// for alphabetical order:$sortby = "`TableA`.`Name` ASC";// for rank by points:$sortby = " /*something here*/ DESC";$query = "SELECT `TableA`.`Name`, `TableA`.`Reference1`, `TableA`.`Reference2`, `TableA`.`Reference3`, `TableA`.`Reference4`, `TableA`.`Reference5` FROM `TableA` ORDER BY $sortby";$result = mysql_query($query, $link) or die(mysql_error($link));while ($row = mysql_fetch_assoc($result)) { $total = 0; $query2d1 = "SELECT `TableB`.`Primary Key`, `TableB`.`Current Points` FROM `Table` WHERE `TableB`.`Primary Key` = '$row[`Reference1`]'"; $result2d1 = mysql_query($query2d1, $link2) or die(mysql_error($link2)); $row2d1 = mysql_fetch_assoc($result2d1)) $total = $total + $row2d1[`Current Points`]; $query2d2 = "SELECT `TableB`.`Primary Key`, `TableB`.`Current Points` FROM `Table` WHERE `TableB`.`Primary Key` = '$row[`Reference2`]'"; $result2d2 = mysql_query($query2d2, $link2) or die(mysql_error($link2)); $row2d2 = mysql_fetch_assoc($result2d2)) $total = $total + $row2d2[`Current Points`]; $query2d3 = "SELECT `TableB`.`Primary Key`, `TableB`.`Current Points` FROM `Table` WHERE `TableB`.`Primary Key` = '$row[`Reference3`]'"; $result2d3 = mysql_query($query2d3, $link2) or die(mysql_error($link2)); $row2d3 = mysql_fetch_assoc($result2d3)) $total = $total + $row2d3[`Current Points`]; $query2d4 = "SELECT `TableB`.`Primary Key`, `TableB`.`Current Points` FROM `Table` WHERE `TableB`.`Primary Key` = '$row[`Reference4`]'"; $result2d4 = mysql_query($query2d4, $link2) or die(mysql_error($link2)); $row2d4 = mysql_fetch_assoc($result2d4)) $total = $total + $row2d4[`Current Points`]; $query2d5 = "SELECT `TableB`.`Primary Key`, `TableB`.`Current Points` FROM `Table` WHERE `TableB`.`Primary Key` = '$row[`Reference5`]'"; $result2d5 = mysql_query($query2d5, $link2) or die(mysql_error($link2)); $row2d5 = mysql_fetch_assoc($result2d5)) $total = $total + $row2d5[`Current Points`]; echo "<tr>"; echo "<td>{$total}</td>"; echo "<td>{$row['Name']}</td>"; echo "</tr>"; }