If you are using php, the function you want is mysql_data_seek($result,0) to reset the result set.
John Lodge -----Original Message----- From: Walter D. Funk [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 2:04 PM To: [EMAIL PROTECTED] Subject: TEMPORARY TABLES Ive just another question, I couldnt get the info from the manual, I suppose thats because I dont know other basics on Mysql .. :-( Ive been using the temporary table, and it works well, but, I can only display the results set just once in my script, is that normal? Ive been trying to paginate the result but when I try to show the second page it seems to be empty. thanks in advance > > if there are too many simultaneous connections which create several > > temporary tables is it posible to > > knock down the server? > > > > thanks in advance > > No, server will not be knocked down by many tables opened, provided > your OS has sufficient number of file descriptors to handle. > --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
