Page 1 of 1

Login specific table view.

Posted: Sat Jun 21, 2003 5:51 pm
by mpriori
Hello,

Im new to this forum, and would like some help if possible.
My PHP/MySQL programming level is novice to intermediate level, so bear with me.

Anyway, my point is that I am trying to write a login script (PHP Login form)that will show a specific table view based on the user who logged. I have a search feature in my web database program that provides a generated table view based on the results. Say, for example, I search for a specific tech, plug in the tech’s name and a table is generated with only the work orders assigned to that specific tech.

My goal is to create a type if login that would do the same thing.
A tech logs in, the text input is compared with a user table in the database, the tech is authenticated and the work orders that are assigned to that tech are displayed on screen via a PHP generated table view etc...

I hope this is not too much verbiage and I was able to articulate my needs accurately. :roll:

Posted: Sat Jun 21, 2003 6:46 pm
by phice
Let's say the tech's id number is 5. And the listings for the tech's jobs are listed by his id number.


When he logs in (with his id, 5), you'll have a program that will search the listings to see if there are any jobs asigned to his id.

// SQL Query
SELECT * FROM `tech_jobs` WHERE `tech_id` = '5'

This should display the results of the current jobs. You'll have to asign numbers to each tech, and each job listing in the table will have to be asigned to each certain tech id.