September 22nd, 2012, 08:59 AM
Selecting unbooked items
Am banging my head to find how to list unused items.
I can list those items which have been used or allocated to a task on an insert query from a collection but those that remain unused escape my best efforts at coding. Any hints or guidlines or suggestions will be much appreciated. Am new on the mysql php platform.
September 22nd, 2012, 01:01 PM
It will be easier to help if you include database structure and queries you tried with.
Generally, you should get result with a query statement like this:
WHERE item NOT IN (
September 23rd, 2012, 12:33 AM
Continuation of unused field
My thanks for the speedy constructive fluid communication.
Originally Posted by MrFujin
I tried and failed many times with your suggestion but by continuous simplification I manged to get it going and then built it up again.
Best regards Peter