simple script for repair center

[jazmine]

I don't know how to write a php script that will allow a customer access to the status of his/her product. I have a basic form with First Name, Last Name, Job Number (which is a receipt that they are given when they give their item to us for repair), email, and comments. My hope is that when the customer enters his/her job number, they can then retrieve the necessary information from my database that will display the status of their product.

The columns in my database are: customer_id, first_name, last_name, job_number, email, date_received, date_proceeded, repair_charges, part_charges, date_shipped, total_sale, total_due, comments.

And I'm trying to write a query that will allow a customer, by entering their Job Number into a form, access the date_received, repair_charges, etc. from the database.

This seems basic, but I'm not too knowledgeable (yet) about the PHP language.

Thank you very much for any suggestions...

[peytonrm]

This is going to be more SQL related than PHP. If all of the columns you mentioned are in a single database table, then this is very easy:

SELECT * FROM TABLE_NAME WHERE job_number=$job_number

You would just have to replace TABLE_NAME with the actual name of your table and assign the actual job number from the customer to $job_number. Take a look at php.net/mysql for information on how to run this query within PHP. This is assuming that job_number is unique in your table. That is, if more than one record can have the same job number then this query would return all of them and you would need to add whatever other data would make each record unique.