my problem comes from pagintion not correctly
displaying the selected amount at one time.
I know where the problem comes from, but can't
figure out a way to correct it.
The problem comes from my outputPicRate function
being contained within a
while ($row = mysql_fetch_array($result))
while the function also maintains it's own sql code....
Notice the $result is actually coming from the
testpaginate() function
Code: Select all
$query = "SELECT * FROM vf_news_pic_rate WHERE published='1' ORDER BY id desc ";
//testpaginate() finishes the above query to display the correct links and article
testpaginate($query, $rows_per_page=3, $pagenumbers=1);
if (!$result) {
echo "<p>" . $messages['error_no_article_found'] . "</p>";
} else {
while ($row = mysql_fetch_array($result)) {
outputPicRate($row['id'], $showall, $show_comment_number=1, $show_rate=1, $show_banner=0, $show_category=1);
}
}but instead grab results directly, the pagination works correctly
and will display however many I want it to at once.
Any ideas how to fix this problem?