Czy da się połączyć takie dwa zapytania w jedno?
Wszystko się opiera o tabele news ale nie wychodzi mi to.. ;/
$query1 ="
SELECT sos_categories.*
FROM sos_news
JOIN sos_categories
ON sos_categories.categories_id = sos_categories.categories_id
ORDER BY news_date_add DESC LIMIT 0, 5
";
$query2 ="
SELECT ".$prefix."news.*,".$prefix."users.*,".$prefix."news_categories.*
FROM ".$prefix."news
JOIN ".$prefix."users
ON ".$prefix."news.users_id = ".$prefix."users.users_id
JOIN ".$prefix."news_categories
ON ".$prefix."news.news_id = ".$prefix."news_categories.news_id
ORDER BY news_date_add
DESC LIMIT $limit, $onpage
";
Prubuje tak ale to nie dziala:
$query3 ="
SELECT ".$prefix."news.*,".$prefix."users.*,".$prefix."news_categories.*,".$prefix."categories.*
FROM ".$prefix."news
JOIN ".$prefix."users
ON ".$prefix."news.users_id = ".$prefix."users.users_id
JOIN ".$prefix."news_categories
ON ".$prefix."news.news_id = ".$prefix."news_categories.news_id
JOIN ".$prefix."sos_categories
ON ".$prefix."sos_categories.categories_id = ".$prefix."sos_categories.categories_id
ORDER BY news_date_add
DESC LIMIT $limit, $onpage
";
Ten post edytował sledzik 1.02.2016, 20:48:09