Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $db = mysqli_connect('localhost', 'xxx', 'yyy', 'xxx') or die ( mysqli_error() );
- function article_widget ($content, $count = 5)
- {
- global $db;
- $widget = '';
- if ($content>0)
- {
- if ($lead == true)
- $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) );
- else
- $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) );
- }
- return $widget;
- }
- echo article_widget(1,10);
Advertisement
Add Comment
Please, Sign In to add comment