PHP Search sort help please

Hi,

I have a simple search which is fine for now. Problem is when it is listing
and sorting.
For example It sorts as follows -
A Guy Called Gerald
A-ha
A-ha
Abigail
Ace of Base
Adamski
Adeva
Adrian Belew
Aerosmith
Agro

I want it to ignore the the spaces and special charackters but not numerical
numbers. From the above sort as you can see first three names should come
after the 'Agro'

What would I need to do and how?

Thanks

-----------Search Form ---------------------------
<form action="preport.php?search=true" method="get" name="searchForm"
id="searchForm">
Artist Search <input name="txtSearch" type="text" id="txtSearch3"
size="10" maxlength="30">
<input type="submit" name="Submit" value="Search">
</form>
-------------------------------


-----------search results ---------------------
<?php
$maxRows_rsReport = 20;
$pageNum_rsReport = 0;
if (isset($HTTP_GET_VARS['pageNum_rsReport'])) {
$pageNum_rsReport = $HTTP_GET_VARS['pageNum_rsReport'];
}
$startRow_rsReport = $pageNum_rsReport * $maxRows_rsReport;

$txtSearch_rsReport = "%";
if (isset($HTTP_GET_VARS['txtSearch'])) {
$txtSearch_rsReport = (get_magic_quotes_gpc()) ?
$HTTP_GET_VARS['txtSearch'] : addslashes($HTTP_GET_VARS['txtSearch']);
}
mysql_select_db($database_connMDB, $connMDB);
$query_rsReport = sprintf("SELECT * FROM mdbTable WHERE AlbumArtist LIKE
'%%%s%%' ORDER BY AlbumArtist+0, AlbumArtist ASC ", $txtSearch_rsReport);
$query_limit_rsReport = sprintf("%s LIMIT %d, %d", $query_rsReport,
$startRow_rsReport, $maxRows_rsReport);
$rsReport = mysql_query($query_limit_rsReport, $connMDB) or
die(mysql_error());
$row_rsReport = mysql_fetch_assoc($rsReport);

if (isset($HTTP_GET_VARS['totalRows_rsReport'])) {
$totalRows_rsReport = $HTTP_GET_VARS['totalRows_rsReport'];
} else {
$all_rsReport = mysql_query($query_rsReport);
$totalRows_rsReport = mysql_num_rows($all_rsReport);
}
$totalPages_rsReport = ceil($totalRows_rsReport/$maxRows_rsReport)-1;
?>

You must create a separate database-field that contains a sort-key. Usually
this field is not displayed, but its contents are calculated from the
visible field and stored.

For example, "A ha," "A Ha", and "A-ha" {*great* band, by the way!!} would
all be stored in a sort-key AHA.



M.E. wrote:

> I have a simple search which is fine for now. Problem is when it is
> listing and sorting.
> For example It sorts as follows -
> A Guy Called Gerald
> A-ha
> A-ha
> Abigail
> Ace of Base
> Adamski
> Adeva
> Adrian Belew
> Aerosmith
> Agro
>
> I want it to ignore the the spaces and special charackters but not
> numerical numbers. From the above sort as you can see first three names
> should come after the 'Agro'
>
> What would I need to do and how?
>

"M.E." <somewhere@downunder.com.au> schreef in bericht
news:bj0u4l$qff$1@otis.netspace.net.au...
> Hi,
>
> I have a simple search which is fine for now. Problem is when it is
listing
> and sorting.

Not an answer to your question but perhaps you have to take a look at the
possibilities of "full-text search" in MySQL.
http://www.mysql.com/doc/en/Fulltext_Search.html

Your search results can be ordered on relevance...

RP