Random approvals

[programmher]

I have a page that allows users to approve one, some, or all records. The corresponding field on my SQL database is a yes/no (0,1) field.

My current query updates either the first record or all records. I am encountering difficulties in associating specific IDs that have an "approved" field that will change from 0 to 1.

Can anyone share some insight on how I can resolve this issue? [sig][/sig]

 

[onirike]

Hi!

Usually what I do in these case, I dont use update the field in the db. I delete them all and readd them all. Way easier to manage. If you have lots of traffic on your site this is NOT a good solution.

This is not a great solution but it usually work and it makes everything easier...

Chris ;-) [sig][/sig]