Re: Small regex help?
| From: | Lorenzo Alberton | Date: | Thu, 13 Oct 2005 08:09:34 +0000 |
| Subject: | Re: Small regex help? | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-21432@lists.php.net to get a copy of this message | ||
Guy Brom wrote:
Can anyone suggest the correct regex to replace col1,col2... with count(*) and strip out everything just before ORDER BY? so for this: SELECT col1,col2... FROM tbl WHERE filter1 filter2 ORDER BY order1,order2 I would get this: SELECT count(*) FROM tbl WHERE filter1 filter2have a look at rewriteCountQuery() in the Pager_Wrapper file: http://cvs.php.net/co.php/pear/Pager/examples/Pager_Wrapper.php HTH Regards, -- Lorenzo Alberton http://pear.php.net/user/quipo