Guest User

Function

a guest
May 18th, 2015
267
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.29 KB | None | 0 0
  1. $db = mysqli_connect('localhost', 'xxx', 'yyy', 'xxx') or die ( mysqli_error() );
  2. function article_widget ($content, $count = 5)
  3. {
  4.   global $db;
  5.   $widget = '';
  6.  
  7.   if ($content>0)
  8.   {
  9.     if ($lead == true)
  10.       $articles = $db->query('SELECT articles_translations.title, articles_translations.article_id, articles_translations.content, articles.only_registered, articles.lead_photo_id FROM articles_categories, articles, articles_translations WHERE articles_translations.published=1 AND articles_categories.category_id='.$content.' AND articles.id=articles_categories.article_id AND articles_translations.article_id=articles_categories.article_id ORDER BY articles_translations.added DESC LIMIT '.$count.'') or die ( mysqli_error($db) );
  11.     else
  12.       $articles = $db->query('SELECT articles_translations.title, articles_translations.article_id, articles.only_registered, articles.lead_photo_id FROM articles_categories, articles, articles_translations WHERE articles_translations.published=1 AND articles_categories.category_id='.$content.' AND articles.id=articles_categories.article_id AND articles_translations.article_id=articles_categories.article_id ORDER BY articles_translations.added DESC LIMIT '.$count.'') or die ( mysqli_error($db) );
  13.   }
  14.   return $widget;    
  15. }
  16. echo article_widget(1,10);
Advertisement
Add Comment
Please, Sign In to add comment