How do I number my search results (1,2,3)?

[c-chan]

I have this php page that displays all the record from the database.
now, I want them to look something like this..

1. result A

2. result B

3. result C

There's a lot of records in my database, so it has several pages.(each page displays 20 records)

now if i go from page 1 to 2 to 3 to 4 ....if its increasing. the numbers shown are correct.
but if i go from page 2 to 1, or from page 5 to 1 the numbering is wrong.


Google use to have numbered search results but its gone now, so I got no reference.
That's what I want to achieve.

Please help. thank you.

[dodie]

Use the pagination algorithm

**Before doing so, use COUNT() the first query to count all records. Only use this to get the numbers for preparation only for your algorithm. Only used to calculate TOTAL pages.

**Second query, Use LIMIT query at the end.
if you got 20 records per page. Create an algorithm to do this.
Page 1 --> LIMIT 0, 20;
Page 2 --> LIMIT 20, 20;
Page 3 --> LIMIT 40, 20;
Page 4 --> LIMIT 60, 20;
Page 5 --> LIMIT 80, 20;
and so forth..... 20 records interval until to the LAST PAGE calculated.

   $interval =  ($input-1) *20;   

To solve for page 1:    answer is 0
To solve for page 5:    answer is 80

To put it simply.... you should make your queries dynamic too, not only the result. Are you using PHPMYADMIN? You should see that coming, the BIG EXAMPLE is just under your nose. You're clicking "next pages" with that application, you could see PHPMYADMIN handle it!!!

rock on dude!!!

[c-chan]

waaaa...superrr supeerrrr.....thank you <3
naa namai limit and all ako page. but i didn't realize i could use it for the numbering..wahahah...thank you so so soooo much! you really halped me ^____^

[maddox22]

Or you can use JQuery w/ tablesorter plugin - mas simple:

jQuery plugin: Tablesorter 2.0

jQuery plugin: Tablesorter 2.0 - Pager plugin

[dodie]

it's about solving, not adding plugins. uggh.
It's about proper execution of extracting data without wasting extra resource that are not used in the SELECT statement. Strictly apply it on a SQL query, simple as that.

You can't satisfy CUSTOMIZED systems if you always depend on extra systems. If you do that, you're just a USER, NOT a programmer.

[c-chan]

patay nag lagot si sir dodie >.<
don't worry. if mag apply man sad ko ug other system sabtun man sad nako ang code.
but with my paging. paging rajud to. no more no less. ^^

@maddox; thnx sa pag share ^^

[MarkCuering]

hahahahahaha.... if you're not a USER, then probably is a DRUG DEALER? hahahaha ang init ng mga ulo ngaun. tapos na ang summer ah. hehehe

[philbluefox]

kalma lang mga guys

[Klave]

@dodie

I think you are taking customized too literally.

The application, or the system for whatever you use it for, is customized for the client's needs.

You don't make it less customized just because you are using tools, plugins, APIs, libraries or the like.

But you have a point when you say that if you always depend on extra systems, you're just a USER, NOT a programmer.

But I cannot fathom how we are able to use these systems if you don't have enough skills as a programmer.

Besides why write code that has already been written.

But to the many "users" make an effort of understanding how these plug-ins work.

It will be a win-win situation by then.

Peace.

[dodie]

@Klave,
It doesn't change the fact that you can't satisfy the customized system created, sometimes plugins are not useful. Think twice.

1st.
Can you solve C-chan's problem without using any plugins?

2nd
How C-chan improve without solving that problem herself?

3rd
Can C-chan become a great programmer is she always use plugins?
------------------
You don't need to answer these questions in this thread......... All I can say is IMPROVISE.