Code: Select all
if ($num_results == 0) {
echo "<p>No articles found!</p>";
} else {
for ($i=0; $i < $num_results; $i++) {
$row = mysql_fetch_assoc($articleresults); Thanks!
Moderator: General Moderators
Code: Select all
if ($num_results == 0) {
echo "<p>No articles found!</p>";
} else {
for ($i=0; $i < $num_results; $i++) {
$row = mysql_fetch_assoc($articleresults); Code: Select all
// Setup pagination controls
$rowsquery = "select * from articles where status=0";
$rowsresults = mysql_query($rowsquery,$connection) or die(mysql_error());
$rows_results = mysql_num_rows($rowsresults);
$pages = new Paginator;
if ($seourls == 1) {
$pages->nav = $siteurl;
} else {
$pages->urlparam = "?";
}
$pages->items_total = $rows_results;
$pages->mid_range = 9;
$pages->paginate();
if ($pages->items_total) {
$query = "select * from articles where status=0 order by date desc".$pages->limit;
} else {
$query = "select * from articles where status=0 order by date desc";
}
$articleresults = mysql_query($query,$connection) or die(mysql_error());
$num_results = mysql_num_rows($articleresults);Code: Select all
$query = "select * from articles where status=0 order by date desc [color=#800000][b]Limit 8[/b][/color]".$pages->limit; <--- Gives php error
} else {
$query = "select * from articles where status=0 order by date desc [color=#800000][b]Limit 8[/b][/color]"; <----Pagination works but it doesn't pull the dataCode: Select all
var_dump($pages->limit);