azz0r
-
Posts
3 -
Joined
-
Last visited
Never
azz0r's Achievements
Newbie (1/5)
0
Reputation
-
and the code to get it working was... $count = mysql_num_rows(mysql_query("SELECT p.time, p.pid, f.type, f.fid FROM $forumzDB.forumz_posts p LEFT JOIN $forumzDB.forumz_forums f ON (p.fid = f.fid) WHERE ((p.time > ".$_COOKIE[\'last_visit\'].") && (f.type = \'anon\' OR f.type = \'publ\'))"));
-
bump :oops:
-
I want to select new posts posted after a cookie string, and where the forum type = anon or publ. However my left join query seems to just close the page off from loading! Help please. [php:1:d36cd25b7f]if($_COOKIE[\'last_visit\']) {$count = mysql_num_rows(mysql_query(\"SELECT p.time, p.pid, f.type, f.fid FROM $forumzDB.forumz_posts p LEFT JOIN $forumzDB.forumz_forums f ON (p.fid = f.fid) WHERE ((p.time > \".$_COOKIE[\'last_visit\'].\") && (f.type = \'anon\' OR f.type = \'publ\'))\")) or die(mysql_error()); if($count < 1) {echo \"No new posts\";} else {echo \'<a href=\"?section=new_posts&np=\'.$_COOKIE[\'last_visit\'].\'\">\'.$count.\' new posts</a>\';}} else {echo \'Cookie was just set\';} ?>[/php:1:d36cd25b7f]