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

Reply via email to