If the id is coming from auto increment, then it would be difficult to guess which is which. I know it is easy if you are looking at it, but programatically it will be difficult for the script. I mean you can do >22, but that is not the proper way.
You will have to add another column on your table to serve as switch. For example, we can add a column named "status" and this column can have a value of either true or false. This way you can set it to false whenever it is needed using the "task" as parameter. We can filter your data like SELECT * FROM 'table' WHERE status = 'true'. Not only that, we can also set the status to true and false whenever it is needed.
SELECT * FROM name WHERE task_my_id NOT IN (SELECT task_my_id FROM subname)
sorry i did not posted some information.
My question is according to this table.
Task_id Member_id Active
1 22 1
2 22 0
3 21 1
4 23 1
5 24 1
here 1 means active and o means not active
now second table
Now i want to filter data like this
22 already done some task which are shown in table 2 (subname).
I do not want to show data for 22 member id, which is already done and store in table 2. and other condition those data also which shown in table 1 on the name of 22.
so means my answer would be
task id member id
I think you got this better now. is there any query for this.