Hi there! --- Christopher Knight <[EMAIL PROTECTED]> wrote: > next: > select cols from table where id > YOUROLDID and > forums = CURRENT_FORUM order by id limit 1 > previous: > select cols from table where id < YOUROLDID and > forums = CURRENT_FORUM order by id desc limit 1
Thanks for your answer.... the question about your proposal is... will I get the very following (or previous) message or will I get any of the following (or previous) messages? Anyway, do you also recommend to number the messages inside each forum? The problem is that they already started to use them... but I could make little changes anyway.... Thanks, Maria __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
