Help Me Pls

erikhillis

Need some help....

<?php
// Connect to the database
$db = mysql_connect("localhost","tbirds_site","123456");
mysql_select_db (tbirds_site);
// Ask the database for the information from the squadlinks table
$sql = "SELECT vs, id, date, type, outcome, description, location, score FROM results WHERE id='{$_REQUEST['id']}'";
if (!$result = mysql_query($sql)) {
print "Invalid query ($sql) : " . mysql_error();
exit;
}
while ($row = mysql_fetch_assoc($result)) {

print "<table border= '0' width= '100%'>
<tr><td width= '100%' valign= 'top'>
Game {$row['id']} {$row['vs']} {$row['date']} 
Outcome: {$row['outcome']} Score: {$row['score']} 
Game played in {$row['location']}. 
 {$row['type']} Game 
Game Description: 
{$row['description']}
</a></td>
</tr>
</table>
";

}

How do I make it so that if nothing is displayed.... (like its just the page results.php instead of results.php?id=1) it shows a message like "Please Make A Selection Above" .. please help

LordShryku

try right at the top of your results.php page to put

if(!$id) {
echo "Please Make A Selection Above";
die();
} else {
do what it's supposed to
}

erikhillis

Thanks, apreciate it.
http://www.thunderbirdsbaseball.com/schedule.php

LordShryku

No worries. Just so you know, the id portion of the url is treated as a GET vairable. So anything you have carried through the URL after the ? can be pulled into your scripts as variables 🙂