CHART RUNS AT POLYHEX.COM
require "../../inc/dbconn.php";
$sql = "select * from chtsingles;";
$resultcount = mysql_query($sql) or die ("Couldn't execute query - count");
$num_rows = mysql_num_rows($resultcount);
if ($num_rows <= 30600) {
$displayblockc= "
Sorry, no longer available.
Currently uploaded $num_rows chartruns
";
echo $displayblockc ;
}
else
{ ?>
Note: Please acknowledge
polyhex.com when using the data!
} ?>
if (isset($_POST[criteria])) {
require "../../inc/dbconn.php";
$audtime = date("d/m/Y H:i:s");
$sql = "INSERT INTO `audit` (`function`, `description`, `searchby`, `searchon`, `audtime`, `IP`, `Browser`) values ('ChartRunsTM', '$criteria', '$searchby', '$searchon', '$audtime', '$REMOTE_ADDR', '$HTTP_USER_AGENT');";
$result = mysql_query($sql) or die ("Couldn't execute query - insert audit");
if ($searchby == "artist") {
if ($searchon == "exact") {
$sqlpeak = "SELECT date_format(EnteredWE, '%d/%m/%Y') as EnteredCht, EnteredWE, Artist, Song, Peak, TotWeeks, ChartRun from chtsingles where Artist= '$criteria' order by EnteredWE LIMIT 200;";
} elseif ($searchon == "anypart") {
$sqlpeak = "SELECT date_format(EnteredWE, '%d/%m/%Y') as EnteredCht, EnteredWE, Artist, Song, Peak, TotWeeks, ChartRun from chtsingles where Artist like '%$criteria%' order by EnteredWE LIMIT 200;";
} elseif ($searchon == "start") {
$sqlpeak = "SELECT date_format(EnteredWE, '%d/%m/%Y') as EnteredCht, EnteredWE, Artist, Song, Peak, TotWeeks, ChartRun from chtsingles where Artist like '$criteria%' order by EnteredWE LIMIT 200;";
}
} elseif ($searchby == "song") {
if ($searchon == "exact") {
$sqlpeak = "SELECT date_format(EnteredWE, '%d/%m/%Y') as EnteredCht, EnteredWE, Artist, Song, Peak, TotWeeks, ChartRun from chtsingles where Song = '$criteria' order by EnteredWE LIMIT 200;";
} elseif ($searchon == "anypart") {
$sqlpeak = "SELECT date_format(EnteredWE, '%d/%m/%Y') as EnteredCht, EnteredWE, Artist, Song, Peak, TotWeeks, ChartRun from chtsingles where Song like '%$criteria%' order by EnteredWE LIMIT 200;";
} elseif ($searchon == "start") {
$sqlpeak = "SELECT date_format(EnteredWE, '%d/%m/%Y') as EnteredCht, EnteredWE, Artist, Song, Peak, TotWeeks, ChartRun from chtsingles where Song like '$criteria%' order by EnteredWE LIMIT 200;";
}
}
$resultpeak = mysql_query($sqlpeak) or die ("Couldn't execute query - chart run");
$i = 1;
while ($row = mysql_fetch_array($resultpeak)) {
$bgcolor = ($i++ % 2) ? '#BCD2EE' : '#D1EEEE';
$enteredchart = $row['EnteredCht'];
$artist = $row['Artist'];
$song = $row['Song'];
$peak = $row['Peak'];
$totweeks = $row['TotWeeks'];
$chartrun = $row['ChartRun'];
$displayblock .= "
$enteredchart |
$artist |
$song |
$peak |
$chartrun |
";
}
?>
Entered Week Ending |
Artist |
Song |
Peak |
ChartRun |
echo $displayblock ?>
| |