[SOLVED] question about mysql

[ohdang888]

ok.

so i want this to be in file called "game.php"... and when a game is displayed it would be "game.php?title=GAMETITLE" (of course, the GAMETITLE would be the name of the game)

so would it atuomatically know to use that info from the same row as "gametitle" is located in??

 

<?php
mysql_connect("localhost", "----", "-------") or die(mysql_error());
mysql_select_db("games") or die(mysql_error());
$result = mysql_query("SELECT title FROM game ")
or die(mysql_error());  
   echo $result;
?>

[revraz]

If you use $_GET sure.

[forumnz]

Assuming the question is "how do i get the right game" - or something - check below.

 

Have this above the connect:

  $game = @$_GET['title'] ;

 

And this in the SELECT:

("SELECT title FROM game WHERE game='$game'")

 

Please correct if im wrong.

Sam.

[ohdang888]

thanks!