function in an sql query statement

[poe]

i cant get this to work, i want to take the title from my db and remove all non-alphanumeric characters, then reverse the title. - this 'newtitle' will be my main sort. i cant seem to figure how to include the function into my sql query statement

 

myfunc($intput) {
$intput = preg_replace("/[^a-z0-9]/i", "", $input);
strrev($intput);
return $input;
}
  
$links = $db->GetAll(" SELECT *, myfunc(`TITLE`) as `NEWTITLE` FROM `{$tables['link']['name']}` WHERE `STATUS` = '2' AND `CATEGORY_ID` = ".$db->qstr($id)."  ORDER BY `NEWTITLE` ASC ");

 

[Barand]

i cant get this to work,

 

And you never will.

 

When you call mysql_query() it goes to the MySQL server for processing and it doesn't even know or care that PHP exists. You can use functions in MySQL but they have to be native MySQL functions (eg NOW(), DATE_FORMAT() etc) or your own custom MySQL function defined in MySQL itself.

[poe]

doh!

 

thats not what i want to hear

 

any suggestions as to what i can do to get my desired results?

 

thanks

chris

[Barand]

$links = $db->GetAll(" SELECT *

              FROM `{$tables['link']['name']}`

              WHERE `STATUS` = '2'

              AND `CATEGORY_ID` = ".$db->qstr($id)." 

              ORDER BY `TITLE` ASC ");

 

then use the function when you process the results in your php script

[poe]

got ya!

 

thankyou.

 

chris

[fenway]

Or you could do this manipulations in SQL, with REPLACE and REVERSE.