Jump to content

Archived

This topic is now archived and is closed to further replies.

azz0r

LEFT JOIN problems

Recommended Posts

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]

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.