I have a datagrid which is successfully loading a database in my .PHP page that loads Title, Location, and Date. I have struck up, struggling to allow only 8 records at a time with a pagination. Also a link has to be created for 1st column where it links the Title list to a new page. I want the new page to load the Description of the selected Title (i.e record) from the previous page. I've an ID column in MySQL with auto increment. Help me to sort it out!!!
Karry.Stewart 0 Newbie Poster
Recommended Answers
Jump to Post@Karry.Stewart
I have struck up, struggling to allow only 8 records at a time with a pagination. Also a link has to be created for 1st column where it links the Title list to a new page. I want the new page to load the Description of the selected …
Jump to PostPagination has been covered to death on this forum. Try searching for 'pagination' first. You'll need the basic variables:
1)
$num_records_per_page
(8 in your case?)
2)$total_records
(from the DB)
3)$num_pages
(calculated asceil($total_records/$num_records_per_page)
)
4)$current_page
(default setting = 1, but then taken from …
All 5 Replies
Reply to this topic Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.