Everah wrote:Nope, what I am saying is just display. Take out the "fulfilled" check altogether and see what comes out. Make sure to make your query order by the fulfilled date. Once you see all the data on the screen you will see what I am talking about when I say use the conditional to make a small notification in the list as to what is fulfilled.
Yeah, I think I can get it by doing this:
for (client names) {
echo client name
for (reqeusts) {
echo user
echo status
if (fulfilled=0){ priority=100}
echo priority
}
Something like that. That would put the priority of the ones set to be hidden well at the bottom.
Now, 2 more random questions if you don't mind:
- How would I go about hiding clients entirely that have no requests? Right now we echo the client names before we check for the fulfilled status, so that would need to be re-done, right? This is just theoretical, and my desire to learn.
- Right now, even if I set my query to sort by priority only, they still mix inside the client. Meaning I could have:
--High Priority - Bob - Client 1
--High Priority - Bob - Client 2
--High Priority - Bob - Client 3
--Low Priority - Bob - Client 3
--High Priority - Bob - Client 3
--High Priority - Bob - Client 4
How could I keep them grouped, inside the client list? I can post a screenshot if you need to see what I mean. It sorts the entire list by priority, but then once we start grouping them (assigning the requests to the proper client) the sorting seems to stop.
This also is just theory. I'm just curious. Right now it works and I could go live with it. I'm just trying to understand ways to make it "better" if I wanted to.
Thank you again for all of your help. This forum never lets me down.