Ok, so I have a simple page that displays the output of a MySQL table. The contents are large, and it is my intention for people to search through it.
The issue is that the database does not index it by highest rank, but rather by order created.
The page orders it for me, and then I use a cheap counter in a loop to rank players.
I already have the anchoring set up, you can search by Rank, SteamID, RP Name, and Wallet.
However, I need the search box. Currently, only SteamID is important.
http://www.triggergaming.net/stats.php is the page. I have one that currently works, but it isn't quite what i want. I want it to not require a page refresh. I currently use header()
as my means of searching by placing that at the top of the page,
<?php if ($_POST["SteamID"]){
header("Location: stats.php#".$_POST["SteamID"]);
exit;
}?>
The rank is stored as $count
, steamid as $row[steamID]
, rpname as $row[rpname]
and wallet as $row[wallet]
EDIT: Now that I think of it, Wallet is not a unique variable, and there can (and will) be duplicates. So I won't index that.