Hi! Futher to a question I had asked, I think that my final problem in this application still has to do with presentation of some records in MySql. Rene and Marcus fruitfully suggested using the html refresh option in frames as a mechanism for presenting records every so many seconds, and at the same time being responsive to user input. This will work perfectly! The last concern is that I am randomly ordering the records and throwing them into a temporary table (there will not be many records -- perhaps 100 at max for any given user). So I was thinking that it would be useful to create a new column in the just-randomized temporary table and place a "1" in the first one, a "2" in the second, and so on, so that the row position (first, second, third, etc.) is reflected in the numbers of that column. This will make it easy to select the records in the (random) order found in the temporary table. Can a guru give me a quick and efficient way of doing this, hopefully on the fly when creating the temporary table via a select from the other table ? (I am using PHP4 on Win ME for this project, by the way). Or is there another way, such as a way to detect the next row's key number in a table? I checked the available functions in the MySql manual but didn't see an obvious way to do this. I'm sure I can do this with scripting, but I'll likely design the most inefficient method. . . Thanks again for your helpful suggestions! Cheers! -Warren --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
