LEFT JOIN problems

[azz0r]

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]

[azz0r]

bump :oops:

[azz0r]

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\'))"));