This is wierd scripted is 100% rigth buth output not

[jorn369]

I got a code that figurse out if the user have watched that movie already or not now the wierd thing about it it let see if he watched buth not if he didnt watched:

 

Code:

$uid = $_COOKIE["cookname"];
$tid = $torrent["id"];
$con = mysql_connect("localhost","jornherm_acbteam","*******");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("jornherm_acbteam", $con);
$query5 = "SELECT uid, tid FROM torrents_seen WHERE uid = '$uid' AND tid = '$tid'";
$gezien = mysql_query($query5);

while($row = mysql_fetch_assoc($gezien))
{
$uid2 = $row['uid'];
$tid2 = $row['tid'];
if (empty($tid2)) 
{
    echo "<img src=\"./images/notseen.png\" border=\"0\">";
} else {
    echo "<img src=\"./images/seen.png\" border=\"0\">";
}
}

 

DB Structure:

 

tid,uid

 

tid=the id of the movie

uid=the username

 

[jorn369]

The screen

 

[attachment deleted by admin]

[jorn369]

Got i solved beceasu ther wasent always a resutl a loop could not started so i did this:

 

<?
$uid = $_COOKIE["cookname"];
$tid = $torrent["id"];
$con = mysql_connect("localhost","jornherm_acbteam","*******");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("jornherm_acbteam", $con);
// select ALL rows
$query = "SELECT * FROM torrents_seen WHERE uid = '$uid' AND tid = '$tid'";
$result = mysql_query($query);

$num_rows = mysql_num_rows($result);
if ($num_rows == 1)
{
echo "<img src=\"./images/seen.png\" border=\"0\">";	

} 	

else 	

{	

echo "<img src=\"./images/notseen.png\" border=\"0\">";	

}


?>