Im trying to pull out some data from my database...
I gave a table called "gamesplayed" in my player database... I have pages roster.php?gamesplayed=df and roster.php?gamesplayed=bf1942... pretty simple, on the page it shows the players from either game... but what do I need to do when I have a played that plays both games?
<?php
// Connect to the database
$db = mysql_connect("localhost","jointops_xfactor","xxx");
mysql_select_db (jointops_xfactor);
// Ask the database for the information from the squadlinks table
$sql = "SELECT * FROM roster WHERE gamesplayed='{$_REQUEST['gamesplayed']}'";
if (!$result = mysql_query($sql)) {
print "Invalid query ($sql) : " . mysql_error();
exit;
}
while ($row = mysql_fetch_assoc($result)) {
print "{$row['name']}<br>";
}
?>
Here is my code now that calls the players... but what do I need to do if the player plays both games? but I dont want their names in another page like roster.php?gameplayed=df&game2=bf1942 ...
Note that I have one table in the roster database that has the gamesplayed value.
