Quote
$inf_newtable[] = DB_FIGURE_USERFIGURES." (
figure_userfigures_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_userfigures_figure_id varchar(100) NOT NULL DEFAULT '',
figure_userfigures_user_id varchar(100) NOT NULL DEFAULT '',
figure_userfigures_sorting varchar(50) NOT NULL DEFAULT '',
figure_userfigures_language VARCHAR(50) NOT NULL DEFAULT '".LANGUAGE."',
PRIMARY KEY (figure_userfigures_id)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
//nav
$fil_settings = get_settings("figurelib");
$max_rows = dbcount("(figure_userfigures_id)", DB_FIGURE_USERFIGURES, "figure_userfigures_user_id='".$userdata['user_id']."'");
$_GET['rowstart'] = isset($_GET['rowstart']) && isnum($_GET['rowstart']) && $_GET['rowstart'] <= $max_rows ? $_GET['rowstart'] : 0;
if ($max_rows != 0) {
$result = dbquery("SELECT * FROM ".DB_FIGURE_USERFIGURES." WHERE figure_userfigures_user_id='".$userdata['user_id']." LIMIT ".$_GET['rowstart'].",".$asettings['figure_per_page']);
echo $result;
$numrows = dbrows($result);
$info['figure_rows'] = $numrows;
$info['page_nav'] = $max_rows > $asettings['figure_per_page'] ? makepagenav($_GET['rowstart'], $asettings['figure_per_page'], $max_rows, 3, INFUSIONS."figurelib/mycollection.php?&") : 0;
echo $info['page_nav'] ? "<div class='text-right'>".$info['page_nav']."</div>" : '';
}
$info['page_nav'] = $max_rows > $asettings['figure_per_page'] ? makepagenav($_GET['rowstart'], $asettings['figure_per_page'], $max_rows, 3, INFUSIONS."figurelib/mycollection.php?&") : "";
print_p("Max rows found - $max_rows ");
print_p("Item per page ".$asettings['figure_per_page']);
Quote
openside();
SQL query for my list of all figures
show all figures
here pagenav?
closeside();
Category Forum
Code Snippet and functions - 8Labels
None yet
Statistics
3 participants
Notifications
You are not receiving notifications from this thread.
Related Questions