why isn't query working?

[ohdang888]

hey. i'm trying to display "related" games. i have the start of a pretty simple code...

i want to take the name of the game, and put it in a link,

 

for example:

a related game is located at "game.php?title=2deep"

i want the link to just look like "2deep"

 

heres my code. i knwo its wrong though because it not working. its not even coming up with an error, its just blank. (but i have data in my db)

<?php
$type = stripslashes($row['type']);
$related_games = mysql_query("SELECT `title` FROM `game` WHERE `type`= '{$type}' ORDER BY RAND('title') LIMIT 10")
or die(mysql_error());  

while($row = mysql_fetch_array($related_games)){       
        echo '<a href="game.php?title=';
        echo $row[0];
        echo '">';
        echo $row[o];
        echo '</a>';
        echo '<br>';
}
?>

the title put out by those two "$row[0]" needs to be the same title.

 

 

 

 

[revraz]

Probably have to use a mod rewrite in your .htaccess

[ohdang888]

how do i do that?

 

 

 

 

 

 

 

 

p.s.- happy new year everyone!

[sasa]

try

<?php
$type = stripslashes($row['type']);
$related_games = mysql_query("SELECT `title` FROM `game` WHERE `type`= '{$type}' ORDER BY RAND('title') LIMIT 10")
or die(mysql_error());  

while($row2 = mysql_fetch_array($related_games)){       
        echo '<a href="game.php?title=';
        echo $row2[0];
        echo '">';
        echo $row2[0];//o<>0
        echo '</a>';
        echo '<br>';
}
?>