Fake Hardware Weekly? :lol Also, to share data (because it's much more useful this way), you'll want to add this code.
SQL to create the table:
CREATE TABLE shareable_ids (PRIMARY KEY shareid INT NON NULL AUTO_INCREMENT, MEDIUMTEXT query_string);
After you execute the query:
$_POST["query"] = mysql_real_escape_string($_POST["query"]);
$insertShareableQuery = mysql_query("INSERT INTO shareable_ids (query_string) VALUES ('{$_POST["query"]}');");
$shareable_id = mysql_insert_id();
In the output section;
print "<a href=\"http://joshuajamesslone.name/gamecharting/sqldirect.php?shareable_id={$shareable_id}\">Permanent Link to this Query</a>";
Right at the beginning before your if($_POST["query"]) line:
if($_GET["shareable_id"])
{
$_GET["shareable_id"] = mysql_real_escape_string($_GET["shareable_id"]);
$getQueryQuery = mysql_query("SELECT query_string FROM shareable_ids WHERE shareid='{$_GET["shareable_id"]}';");
$getQueryRow = mysql_fetch_array($getQueryQuery);
$_POST["query"] = $getQueryRow["query_string"];
}
If you're smart, you could also check for the presence of a pre-existing shareable copy of the user's query and prevent duplicates from being added... but realistically that's not a huge concern.
All of this code assumes that you're not using a database wrapper class, that you're not using Object Oriented database stuff, that you are smart enough to have your PHP installation configured securely, etc.
I don't have access to PHP/MySQL right now so some of my syntax is probably off.
Fun Query-- Best ten software weeks ever (for the data that Joshua has):
SELECT SoftwareWeekly.SalesWeekly, SoftwareInfo.TitleEnglish, SoftwareWeekly.Week FROM SoftwareWeekly,SoftwareInfo WHERE SoftwareInfo.GameID=SoftwareWeekly.GameID ORDER BY SalesWeekly DESC LIMIT 0,10;
