How to only select one item once, read below to see what I mean....

[TonyU]

[tt]
Here's the problem I'm having

I have this page displaying different jobs per say and where users can select as many jobs to work on for any day, the question is:
How can I code the page so the user does not select the same job he\she already selected once ?

For example:
If I pickup job numbers
5,8,& 10
and go about my business.....
.... then I come back 2 hours later or so and try selecting job number 8 again I'm not allow to...

Thanks in advance..

[tt]"A Successful man is one who can build
a firm foundation with the bricks
that others throw at him"
[/tt]

​

 

[mozingod]

Store a cookie containing what they've selected and check it every time? Or if you want more elaborate, do a whole username/password login system and store what they've selected in a database somewhere? Darrell Mozingo
MCSA, A+, Network+, i-Net+, MOUS 2000 Master

 

[timothymo]

it depends what u want to do ...

say, a job is only allowed to be selected only once, then simply add one more col to ur table : selected (bool)

and, if a job is only allowed to be selected only once by one user, others can still selected, then ... u need to create a user login control, and keep tracking what are the jobs selected by a particular user ...

hope i understood ur Q well ...