How would I write a regexp on a MySQL query

[laredotornado]

Hello,

Using PHP 4 and MySQL 4, how would I write a function such that it
takes a valid MySQL query, and a column on which to order the query,
and return a new query ordered by that column?

$query = formNewQuery($query, $orderByCol);

An assumption you can make is that the query will never have multiple
columns on which to order -- e.g. ("ORDER BY COL_A, COL_B"), however
the query could contain the "DESC" keyword -- "ORDER BY COL_A DESC".

Thanks, - Dave

[Marcin Dobrucki]

la***********@zipmail.com wrote:

Using PHP 4 and MySQL 4, how would I write a function such that it
takes a valid MySQL query, and a column on which to order the query,
and return a new query ordered by that column?

$query = formNewQuery($query, $orderByCol);

An assumption you can make is that the query will never have multiple
columns on which to order -- e.g. ("ORDER BY COL_A, COL_B"), however
the query could contain the "DESC" keyword -- "ORDER BY COL_A DESC".

require_once ('DB.php'); // PEAR::DB
//.. $db =& initialize connection, etc.

$query = 'SELECT * FROM table ORDER BY ! !';
$param = array('column_name', $order);
// where $order = 'ASC' or 'DESC' or ''
$res =& $db->query($query, $param);

// voilá!

//Marcin

[Marcin Dobrucki]

Alternatively you can, ofcourse, do something like this:

function munchQuery($query, $col_name = '', $sort_order = '') {
if ( !empty($col_name)) {
$query .= ' ORDER BY '.$col_name;
if ( !(empty($sort_order)) {
$query .= ' '.$sort_order;
}
}
return $query
}

// but IMHO that's hard to maintain properly.