Posted by lawrence k on 04/13/06 05:51

Want to replace the limit clause in a query, but can't get it right.
What's wrong with this:

$pattern = "(.*)limit (.*)";
$replacement = '$1';
$replacement .= "LIMIT $limit";
$replacement .= '$2';
$query = preg_replace ($pattern, $replacement, $query);


All I get back is:

LIMIT 700

• Next in forum: Re: phpPgAdmin problem
• Prev in forum: Re: php CMS
• Thread view: REGEX: can't seem to replace LIMIT clause in query using preg_replace ($pattern, $replacement, $query)

[Reply to this message]