--- Jay Blanchard <[EMAIL PROTECTED]> wrote: > [snip] > 1- I need a way to mark (somewhere) that the record > came up in a search. i.e. 700 records were returned > in a search, each one needs to a) be marked that it > came up in a search b) that number needs to be > incremented > > 2- Step further, out of those 700 records, user > chooses to view details on 30 of them - those > records > now need to be marked as "viewed", again , > incrementing everytime they are viewed is needed. > [/snip] > > Additional tables to hold status information is in > order. You would > query those tables for their current counts and > update as required. >
I'm thinking this through. In other words, when a record is returned in a search , and insert statement makes an entry into another table? This will involve scripting as well as sql statements ? Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]