The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Split Mysql Fetch Array
The-Shadow
post Oct 17 2013, 04:24 PM
Post #1


Novice
**

Group: Members
Posts: 21
Joined: 20-September 13
Member No.: 19,759



Hey guys,

Got a new problem. I created a mod panel but know i want to show it in a table.
So Username, something, something, something

I'm doing this this way:

$SelectInfo = mysql_query("SELECT * FROM members");
$GetRows = mysql_fetch_array or assoc($SelectInfo);

Then im using the $GetRows to get the values of the database. The problem now is: i want to get like 10 rows per page. And then split it and display it in a table. But every players has its own row. So i can do this 1 by 1 but that is slowing my PHP Performance down. Is there a way to split it and display it in a table with 10 rows per page?

Extra Info, i DONT Have PROBLEMS with this:

Ordered by ID's. (First members gets ID(1) second gets(2) so i want to display by registerdate)

PROBLEMS ARE BOLD
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Christian J
post Oct 19 2013, 04:22 PM
Post #2


.
********

Group: WDG Moderators
Posts: 8,006
Joined: 10-August 06
Member No.: 7



Have you solved this yet? Maybe array_chunk() can be used.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post

Reply to this topicStart new topic
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 18th January 2019 - 02:49 AM