Symbols and Numbers

[Jamz]

I have made a site which desplays sites which i put in, and they are sorted in alphabetical order... So far i have evrything working appart from the numbers and symbols. I already have the code like this:

mysql_query('SELECT * from sites where username like "a%"',$db)

mysql_query('SELECT * from sites where username like "b%"',$db)

mysql_query('SELECT * from sites where username like "c%"',$db)

and so on... but how can i use this to desplay all numbers and symbols like @'s and $'s and 1's 2's and so on?

[ScubaKing22]

Why reinvent the wheel? Use SELECT * FROM sites ORDER BY username ASC

[Jamz]

No... each one's in a different link...

heres the site... http://www.saudi-cars.net/pcfwl/index.php

[ScubaKing22]

Ah sorry my mistake didn't understand your question correctly 😉 Well you could select them all then when looping through each item or however you do it just use a string function to see if the first character is alpha or numeric then display all the non-alpha ones.

[Jamz]

Could you tell me how to do that?

[Jamz]

Can someone help me please.