[martin_1988]

I'm currently working on a game site and I need to display the latest games added. But when I try to display the results I get the same results over and over.

Here is the code:

Code:

<?

$local ="";
$user =""; //Usuário do DataBase
$senha =""; //Senha do DataBase
$db =""; //DataBase

if($conectar = @mysql_connect($local,$user,$senha)) {
@mysql_select_db($db,$conectar) ;
}
else {
$error = mysql_error() ;
echo "No se pudo conectar a la base de datos por: <b>$error</b>" ;
}
$most = 10;
$sql4 = mysql_query("SELECT * FROM jogos order by id desc LIMIT 0,".$most);
$i = 0;
?>
<?
while($show = mysql_fetch_array($sql4))
{
$i++
?>
 <table width="100%"  border="0" cellspacing="0" class="menu">
<tr>
 <td width="124" align="center" valign="top" style="border-bottom:1px solid #B6A792;"><a href="<?= "gameen.php?id=".$show[id] ?>" title="<?= $show['jogo'] ?>"><img border="0" height="82" src="<?= $jogo->Screen; ?>" width="120"></a></td>
 <td valign="top" style="padding-left:4px;border-bottom:1px solid #B6A792;">
  <table width="100%" cellspacing="0" cellpadding="0" border="0">
   <tr>
    <td align="left"><a href="<?= "gameen.php?id=".$show[id] ?>"><b><?= $show['jogo'] ?></b></a></td>
    
    <td align="right" width="200">( <small><?= $show['date'] ?></small> )&nbsp;&nbsp;</td>
   </tr>
  </table>
  <div><b><a href="gameen.php?ano=<?= $jogo->ano; ?>"><?= $jogo->ano; ?></a></b>, <?= $jogo->empresa; ?></div>
  <div><a href="gameen.php?categoria=<?= $jogo->categoria; ?>"><?= $jogo->categoria; ?></a></div>
 </td>
</tr>
 </table><?
}?>

I need to display them all each row with it's unique information. Thanks!

[martin_1988]

Anyone? Thanks!

[wirehopper]

Post the output (text is fine) and explain why it isn't what you want.

[job0107]

How does $jogo->Screen get it's value?
I would assume that for each record in the database you have an image file name stored.
And for each record that is displayed there is a different image file.
So why are you assigning $jogo->Screen to the src of each image element?
Shouldn't you be assigning the image file name from the database, to the image element, instead of $jogo->Screen?