PHP Genius Bar Script

I'm looking to make something like the genius bar where people can sign up to meet with a certain tech at a certain tech, then it will e-mail the tech where they can approve or deny. I've been trying to make it, but struggling.

 

sounds like a sql and php combo. not 2 hard but I would need a lot more info to help much.

 

Like what?

 

well first what is the genius bar.

How are the tech names organized now ? Do you have them in a sql data base?
do you have the email address for each in a data base?

Get me a list of the techs and emails address for each one and I can build a script with a drop down that will let you select the tech ,a time,a date, add a short message and send it to the tech.

If you want the system to see if the tech is already spoken for at the desired time that could get complicated fast. I am not sure about that .

I did a little research on the genius bar
Looks more like good idea.
if they are techs in your retail store it would be easy. to store the address and tech names in a sql data base along with a small description of the techs quals.
Then either let the customer fill out a form that contacts a tech of their choice or sends an email to all techs so who ever is open at the desired time can respond.

The form could also be setup to pull only tech names that are ava after the customers picks a time. It would take updating from you or your admin but could be done.

 

Hmmmm.... okay. I typed up all the answers to this and then figured I'd have another go at it. Hahahah. Let me get back to you. Thanks though!!