I'm helping a friend redo his database queries and have run into something that I need some advice on. Let me first say that I am not a PHP developer, so please bear with me.
I have two queries that I can merge together, but I will need to separate the data later. For example, let's say I have a book collection section of my site. It allows users to rate books and optionally write a review. What I would like to do is get all this data in one query (I already have the query for this) and then 'query' the recordset to split the results, those who reviewed the book and those who only rated it.
Is this possible in PHP? I've done it in other languages, but not being a PHP developer, I have no idea where to start.
Thanks in advance.