mysql alphabetical pagination

letters work but what about number and symbols

[antriver]

Hi,
I've got a database full of songs for people to request on my site. I've got alphabetical pagination working fine but I also want a page for artists that start with a number or a symbol instead of a letter.

Here's the code...

if (!isset($_GET['letter'])) {$letter = "A";} else {$letter = $_GET['letter'];}
 echo '<div align="center"><b>';
 for ($i=65; $i<90; $i++) { 
 if ($letter!= chr($i)) {echo '<a href="index.php?letter='.chr($i).'">';}
 echo chr($i)."&nbsp;";
 if ($letter!= chr($i)) {echo '</a>';}
  }    
 echo "</b></div><p>";
 
 $query="SELECT * FROM songs WHERE artist LIKE '".$letter."%'";

So I just want to add one link before A B C.... for everything that isn't a letter

Thanks in advance :)

[borntobeweb]

Welcome to WebmasterWorld antriver.

You can use either the MySQL function ASCII or SUBSTRING to do this. So to fetch all artists whose name doesn't start with an alpha character:

$query="SELECT * FROM songs WHERE ASCII(UPPER(artist)) NOT BETWEEN ASCII('A') and ASCII('Z')";

or

$query="SELECT * FROM songs WHERE UPPER(SUBSTRING(artist,1,1)) NOT BETWEEN 'A' and 'Z'";

Hope this helps.

[antriver]

thanks, that works great :)