Hi,
I want my sql statement in array, but the "WHERE", "ORDER" or "GROUP" is optional.
For example:
1.)
SELECT str_name FROM users
$arr_sql[ 0 ] = 'SELECT str_name FROM users';
$arr_sql[ 1 ] = 'str_name';
$arr_sql[ 2 ] = 'users';
2.)
SELECT str_name FROM users WHERE int_id = 1
$arr_sql[ 0 ] = 'SELECT str_name FROM users';
$arr_sql[ 1 ] = 'str_name';
$arr_sql[ 2 ] = 'users';
$arr_sql[ 3 ] = 'int_id = 1';
...
USING EREGI !!!
Example:
eregi( 'SELECT (.) FROM (.) WHERE (.) GROUP BY (.) ORDER BY (.*)', $str_sql, $arr_sql );
But WHERE, GROUP BY, ORDER BY isn't required.
Thanks
