- print_r: documentation ( source)
- preg_match_all: documentation ( source)
- array_unique: documentation ( source)
<?php
$query = "SELECT
r.revision_id,
r.content_id,
r.user_id,
r.entry_name,
r.entry_description,
r.date_added,
r.date_modified
FROM modules_acls_entries_content_revisions r
INNER JOIN modules_acls_entries_content c ON (c.content_id = r.content_id)
WHERE r.revision_id = ?;";
if(preg_match_all("/((FROM|JOIN|,) ([_\w]*) )/", $query, $matches)) {
$tables = array_unique($matches[3]);
print_r($tables);
}