Howdy,
Running into a wall trying to figure out the best way to accomplish the
following:
I have a web form that allows the user to ask a question about a certain
topic.
On the backend I have, say, five people available to answer questions
for each topic. They are stored in a MySQL table.
What I want to do is select one of the five people and send the question
to them. That part is easy. The next part is where I am running into a
stumbling block.
The next time someone submits a question on this topic I want to select
from the remaining four people/records who have not been contacted.
Then the next time select from the three people not contacted, then two,
then one.
After all five have been contacted I want to reset their records so that
I am choosing from all five again.
Thoughts on how to accomplish this?
Thanks,
-Aaron
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php