Adapt MySQL 4 query to MySQL 3

[AvrilBoi]

Hi everyone!
I recently had the opportunity to be hosted by a friend, but on his server he has MySQL 3.x and I used MySQL 4.x.
With my old hosting I used this query in a php page:
[code]order by substring_index(a.title,\'#\',1), cast(substring_index(a.title,\'#\',-1) as unsigned) ' . $limit;[/code]
and everything went great... now I get an error:
[b]mySQL error: You have an error in your SQL syntax near '(substring_index(a.title,'#',-1) as unsigned) LIMIT 0,42' [/b]
so I think this error is related to the different mysql version.. since I'm not very expert, can you please tell me a way to get the same result without having any error? Thanks

[fenway]

Try:

[code]
order by substring_index(a.title,\'#\',1), substring_index(a.title,\'#\',-1)+0) ' . $limit;
[/code]