I'm trying to write a script to allow a customer to access the status of their order. I have set up the database properly, including all the fields necessary. I have successfully written a registration script, allowing the customer to register his/her details into the database, but where I'm struggling is making the query for a customer with a job number (who enters first and last name, and his/her job number) the ability to access information from the database that shows their status.
I guess the question is how do I query a field (job number) to return multiple fields (i.e. the status of their repair).