PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
You will get a resultset. And you can iterate through this resultset.
I guess that the resultset is just a table and you can iterate through it based on the row identifier. Can you delete rows from the resultset? (not from the database)
mysql_query() returns result set. mysql_result() return a row from a result set, not a result set. No you cannot delete a row from the result set. You should look at using mysql_fetch_*() functions instead of mysql_result() for the reasons mentioned in the manual.
Oh okay thanks! I have got two data collections and what I actually want to do is say something like
SELECT * FROM <Table> WHERE <field> NOT IN (SUBQUERY).
The subquery really performs great but when I execute the whole query it performs bad so Iam looking into alternatives. I thought maybe I can solve it in PHP by creating two loops and each time I found something I can delete the row in the result set so the list gets smaller and so come closer to the required collection data.