Member Avatar for mikeshadow

So i've come over a problem, i need to use something similar like this

set @num = 0;
select * from (
    select *  
    , @num := @num + 1 as row_number
    from my_users as info
    order by Score desc 
) as ii

any ideas how i can query this in php?
or at least some instructions how to multiquery in php?

  • 2 Contributors
  • 1 Reply
  • 58 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by diafol
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.