Unnamed

<?php 

$username="videogames";
$password="garyrocks";
$database="videogames";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

include("includes/header.php");

if (isset($_POST['q']))

{

$search_query = mysql_escape_string(strip_tags($_POST['q']));

$sql = "SELECT * 
        FROM image_media AS im, game AS g 
        WHERE im.gameID = g.gameID AND g.title = `%$search_query%`";

$sql2 = "SELECT * 
         FROM image_media AS im, game AS g, game_character AS gc, character AS c 
         WHERE im.gameID = g.gameID 
           AND g.gameID = gc.gameID 
           AND gc.characterID = c.characterID 
           AND c.name = `%$search_query%`";
}
?>

<div id="container">

<div id="header">

<a href="index.php"><?php include("includes/banner.php"); ?></a>

</div>

<div id="sidebar-a">

<div class="page_section">

<?php include("includes/about_us.php"); ?>
</div>


</div>

<div id="content">

	<div class="page_section_three">
	<?php include("includes/search_form.php"); ?>
    
	</div>

<div class="main">

<?php

//$result = mysql_query("SELECT * FROM `image_media`,`game` WHERE image_media.gameID=game.gameID");
$result = mysql_query($sql) or die(mysql_error());
$num = mysql_numrows($result); 
//$result2 = mysql_query($sql2) or die(mysql_error());
$num2 = 1; //mysql_numrows($result2); 

echo '<h3><center>Search Results</center></h3><br />';

if($num)   {

for ($i = 0; $i < $num; $i++){
   $gameID = mysql_result($result, $i, "gameID");
   $characterID = mysql_result($result, $i, "characterID");
   //echo 'gameID = ' . mysql_result($result, $i, "gameID") . '<br />';
   echo '<center><div><a href="http://voyager.ischool.utexas.edu/~videogames/game.php?game=' . mysql_result($result, $i, "gameID") . '" >'.mysql_result($result, $i, "title") .'</a><br />';
   echo '<a href="http://voyager.ischool.utexas.edu/~videogames/game.php?game=' . mysql_result($result, $i, "gameID") . '" ><img src="images/games/'. mysql_result($result, $i, "file_name") .'" class="search" alt="'. mysql_result($result, $i, "title"). '" width="125" height="100" /></a><br /><br /></div></center>';	
}}
/*
if($num2)  {

for ($i = 0; $i < $num2; $i++){
echo '<center><div><a href="http://voyager.ischool.utexas.edu/~videogames/character.php?character=' . mysql_result($result2, $i, "characterID") . '" >'.mysql_result($result2, $i, "name") .'</a><br />';
   echo '<a href="http://voyager.ischool.utexas.edu/~videogames/character.php?character=' . mysql_result($result2, $i, "characterID") . '" ><img src="images/characters/'. mysql_result($result2, $i, "file_name") .'" class="search" alt="'. mysql_result($result2, $i, "name"). '" width="125" height="100" /></a><br /><br /></div></center>';
            }
*/
/*   
echo 'title = ' . mysql_result($result, $i, "title") .  '<br />';
   echo 'description = ' . mysql_result($result, $i, "description") . '<br />';
   echo 'ESRB rating = ' . mysql_result($result, $i, "ESRB_rating") . '<br />';
   echo 'alternate controller = ' . mysql_result($result, $i, "alternate_controller") . '<br />';
   echo 'website link = ' . mysql_result($result, $i, "website_link") . '<br />';
*/
}
if(!$num && !$num2) { echo "No results"; }

mysql_close();

?>
</div>
<div id="footer">

<?php include("includes/footer.php"); ?>

</div>
</div>
</div>

 
</body>
</html>