Search same pattern several times.

[Loccie]

preg_match("/FROM (\w*),/", $query, $tables);

This is what I have now. I'd like to extract all the tables from the query. With this code, it only returns the first.
Example:

SELECT * FROM table1,table2

This will return table 1, but not table2. How do I make it repeat the search for all the patterns? Or should I forget about regex and use string functions to extract the tables?

[GustTheASGuy]

Boop

(\w*(,\w*)*)

[Loccie]

This doesn't seem to work at all.

[Craige]

At 11/4/09 10:55 AM, Loccie wrote: This doesn't seem to work at all.

Paste a print_r of Gusts' expression, please. He should be close.

[Loccie]

At 11/4/09 12:10 PM, Craige wrote:

At 11/4/09 10:55 AM, Loccie wrote: This doesn't seem to work at all.

Paste a print_r of Gusts' expression, please. He should be close.

Right, sorry. I totally forgot that.

/(\w*(,\w*)*)/

Array
(
    [0] => SELECT
    [1] => SELECT
)

I also tried:

/FROM (\w*(,\w*)*)/

Array
(
    [0] => FROM Music_Artists,Music_Pictures
    [1] => Music_Artists,Music_Pictures
    [2] => ,Music_Pictures
)

[GustTheASGuy]

It's a pattern to match comma-separated words, as it obviously doesn't have the FROM. Are you incapable of reading a short regexp?
You added FROM and it works, take the item at 1 and split it.

[Loccie]

At 11/4/09 01:27 PM, GustTheASGuy wrote: It's a pattern to match comma-separated words, as it obviously doesn't have the FROM. Are you incapable of reading a short regexp?
You added FROM and it works, take the item at 1 and split it.

I did the second one first but I was looking to get an array that already had the info I wanted. Anyway, I tried what you said and then I tried using only string functions; the string functions were a lot faster according to microtime, so I'll use those. Thanks for the regex anyway.

[GustTheASGuy]

You wanted something regexps don't do. Unless you use a long pattern of (\w*),(\w*),(\w*)