ranking list

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Irlan agous

    ranking list

    Hallo All

    I have a dating site with the tablke

    clients(clienti d, profiletext)
    reactions(logid ,persid)

    Now in the persid are the people reacted to from log id. Nowe i want to make
    a query that counts the number of persid, and put them in a top5 list, But
    every persid has a number of records. I did something like this

    $query = "select id,form.clients .profiletext,pe rsid from reactie,clients
    where persid = form.id"

    but now i get all the data, it has to be separated into the different
    persid's

    Irlan



Working...