jorn369 Posted February 19, 2011 Share Posted February 19, 2011 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 Quote Link to comment Share on other sites More sharing options...
jorn369 Posted February 19, 2011 Author Share Posted February 19, 2011 The screen [attachment deleted by admin] Quote Link to comment Share on other sites More sharing options...
jorn369 Posted February 19, 2011 Author Share Posted February 19, 2011 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\">"; } ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.