I have a products table which contains all my products. Those products table gets filled permanently with new products. However, I want to have the possibility to “hold up”/”pin” certain products to a place in the returned query collection. Means, I want to set something like rank_index which contains the number the product should have in the returned query collection.
Tag: ranking
Basic ranking of MySQL data and printing result with php
I have a table which in which I want to rank rows where one of the columns equals a value I have defined. For example in this table I want to get all rows where Col1 = a, then find what is the rank …
Calculating rank in PHP/MySQL
I’ve got a table in MySQL lets just say for example its got two fields Username, GameName and Score. I want to calculate the rank of a user for an indivudal game name so I could do the query SELECT * …