How about using the lower() function?
Leon Vismer wrote:
Hi
I would like to convert from one naming convention within a sql statement to
another.
I have the following,
<code>
$str = "insert into userComment (userID, userName, userSurname) values (0,
'Leon', 'Vismer')";
$match = array(
"/([a-z]+)(ID)/",
"/([a-z]+)([A-Z])/"
);
$replace = array(
"\$1_id",
"\$1_\$2"
);
$nstr = preg_replace($match, $replace, $str);
echo $nstr ."\n";
</code>
the above gets me to
insert into user_Comment (user_id, user_Name, user_Surname) values (0, 'Leon',
'Vismer')
however I want to get to
insert into user_comment (user_id, user_name, user_surname) values (0, 'Leon',
'Vismer')
Some help from the regex experts ;-)
Many thanks
--
Leon
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
