[Digma]

Thanks for the information. I'll dive into it and see if I can come up with something properly working going from both your information. Again, thanks!

--------------- Added [DATE]1254303795[/DATE] at [TIME]1254303795[/TIME] ---------------

Problem solved I came up with the following query and it works:

PHP Code:

$query="select b.id, b.publicationdate, b.title, b.shortdesc, b.cat_id, b.author_id, c.naam, d.username from si_news_cat c, si_news b INNER JOIN forums.fo_user d ON d.userid=b.author_id where b.publicationdate <= now() and c.id = b.cat_id order by b.publicationdate desc limit 0,10"; 


Thanks again for the pointers.