Home / Articles / Accessoires


Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/themobi/public_html/actualites/news_archive.php on line 25
SELECT n.id,UNIX_TIMESTAMP(n.datetime) as date, n.views, DAYNAME(n.datetime) as dname, DATE_FORMAT( n.datetime, '%e %M %Y' ) as datestring, n.subject,n.vbul_thread, f.views as forum_views FROM news AS n LEFT JOIN newscomments nc ON nc.newsid=n.id LEFT JOIN themobi_pdaforum.thread AS f ON n.vbul_thread = f.threadid WHERE n.status = 2 AND n.datetime > DATE_SUB(NOW(), INTERVAL 1 MONTH) AND n.datetime < DATE_SUB(NOW(), INTERVAL 0 MONTH) ORDER BY date DESC