sql - how to know the row number from certain id

Asked Nov 23 '16 at 16:38

Active Nov 23 '16 at 16:38

Viewed 34 times

Sorry for the title. I'm so confuse what title should i write. Editing my question title is allowed.

i have this url : example.com?id=33

thats mean: SELECT content FROM article WHERE id=33

content id 33 will shown in thats page.

but, in the footer i want to give pagination. because id=33 is the 17th row. the pagination will be

15 16 [17] 18 19

the problem is:

how to know the row number of id 33?

edited Nov 23 '16 at 16:38

Funk Forty Niner

asked Nov 23 '16 at 16:38

plonknimbuzz

1

Rows doesn't really have a row number... it all depends on the order you apply to your table... – Jordi Nebot Nov 23 '16 at 16:39
thanks @JordiNebot . but my friend tells me the answer via Whatsapp second ago. i will post the answer – plonknimbuzz Nov 23 '16 at 16:42
1

Or the `ORDER BY` that you apply to your query to be more precise – RiggsFolly Nov 23 '16 at 16:42
1

This might be what you want? http://www.mysqltutorial.org/mysql-row_number/ – James Casey Nov 23 '16 at 16:43
the answer is : SELECT count(*) FROM article WHERE id <=33 – plonknimbuzz Nov 23 '16 at 16:45
thanks for everyone. i appreciate for your attention and help. – plonknimbuzz Nov 23 '16 at 16:46
2

Well its an answer, but probably not to the question asked – RiggsFolly Nov 23 '16 at 16:46
1

You should still `ORDER BY id` otherwise you will get rows back in an indetermiate order – RiggsFolly Nov 23 '16 at 16:46
i see. thanks @RiggsFolly – plonknimbuzz Nov 23 '16 at 16:48

0 Answers0