if i would like to check whether the member is in the top 50 list of a match , how can i check , any function can preform this purpose
thanks
We'll need a little more info than that. Where is this data set from; a database, an array, an object or something elese? Provide some code if you can please. Cheers Bubble
there are two coloumns in the database , one is
member ID and second is the mark
there are totally 100 data
i want to know whether a specific member is in the top 50
data in mysql
I'm assuming that the "mark" column is of type int. Try this query:
select memberID from table where mark > 50