Re: [PHP-DB] mysqldump via php

2006-06-30 Thread Jeffrey
Thanks all for the help! exec() seems the best option. Jeffrey Miguel Guirao wrote: You could use exec() within PHP! -Original Message- From: Adrian Bruce [mailto:[EMAIL PROTECTED] Sent: Jueves, 29 de Junio de 2006 06:31 a.m. To: Jeffrey Cc: PHP DB Subject: Re: [PHP-DB] mysqldump

Re: [PHP-DB] LIMIT

2006-06-30 Thread Chris
If you're using MySQL then: SELECT SQL_CALC_FOUND_ROWS * FROM aTable LIMIT 5 SELECT FOUND_ROWS() It's in the mysql documentation under SELECT syntax I believe. Chris Dwight Altman wrote: Is there a way to get the number of rows that would have been returned had there not been a LIMIT clause

RE: [PHP-DB] LIMIT

2006-06-30 Thread Dwight Altman
Thanks, but that's an additional query. I was wondering if there may be a PHP function that can operate on the $result or perhaps $link of the single query that uses a LIMIT clause and have the information [count(*) had there not been a LIMIT clause count_no_limit(*) maybe? even though there was