RE: [PHP-DB]

not really, why not take a different approach and get all the records (it seems like you want to use them all eventually anyway) and then just limit what is shown or calculated with php rather than MySQL? I think you need to give us a bit more information on what it is your trying to do as its difficult to guess your situation. Cheers Dan -----Original Message----- From: nikos [mailto:nikos@qbit.gr] Sent: 23 April 2003 15:15 To: Snijders, Mark Cc: PHP-mailist Subject: Re: [PHP-DB] RE: [PHP-DB]Is there another way? With LIMIT I must set the "length" of select ( ... LIMIT 4, #). So I have to select the Last_insert_id() first. Is there another "fancy" way to select NOT THE FIRST 3 records but the rest of them? ----- Original Message ----- From: Snijders, Mark To: 'nikos' Sent: Wednesday, April 23, 2003 4:15 PM Subject: RE: [PHP-DB] why without limit if i may ask? -----Original Message----- From: nikos [mailto:nikos@qbit.gr] Sent: woensdag 23 april 2003 15:17 To: Matt Schroebel Cc: PHP-mailist Subject: Re: [PHP-DB] Thanx Matt but it doesn't help me much. I need a solution without using LIMIT. ----- Original Message ----- From: Matt Schroebel To: nikos ; PHP-mailist Sent: Wednesday, April 23, 2003 3:47 PM Subject: RE: [PHP-DB] > -----Original Message----- > From: nikos [mailto:nikos@qbit.gr] > Sent: Wednesday, April 23, 2003 8:22 AM > To: PHP-mailist > Subject: [PHP-DB] > With LIMIT we can select (lets say) the first 3 records. > How can I select the rest of the records without LIMIT? Read the comments in the manual here: http://www.mysql.com/doc/en/LIMIT_optimisation.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php