Hi all.
I've got one problem with %subj%. I need to get 1st appearance of any alternative pattern, but my regexp get last.
Remember .* is greedy by default you need to use .*? also instead of using [[:space:]] I might suggest using \s, it will make it shorter
in $out[2] (input) is "columns FROM tables WHERE conditions ORDER BY sth DESC LIMIT 1 OFFEST 0"
preg_match("/[[:space:]]*(.*)[[:space:]]+from[[:space:]]+(.*) [[:space:]]+whe
re[[:space:]]+(.*)[[:space:]]+(order by|group by|having|limit)(.*)/is",
$out[2], $out);
/^\s*(.*?)\s+from\s+(.*?)\s+where\s+(.*?)\s+(order by|group by|having|limit)(.*)/is
This will produce: Array ( [0] => columns FROM tables WHERE conditions ORDER BY sth DESC LIMIT 1 OFFEST 0 [1] => columns [2] => tables [3] => conditions ORDER BY sth DESC // but here I need only "conditions" [4] => LIMIT // and here shloud be ORDER BY sth DESC LIMIT [5] => 1 OFFEST 0 )
I'm not entirely clear how you want to capture the order by|group by| etc..
Curt --
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
