PHP/MySQL: Select based on first letter or number

[Trent_Hatred]

Hey Folks,

I'm working with a fairly large database of company names, and I'm looking for a way to display them all in a format similar to the following:

A|B|C|D|E|F|G|H|I|J|K|L|M|N|O|P|Q|R|S|T|U|V|W|X|Y|Z|#

Click on a letter, and all companies that start with the selected letter are displayed.

I have it ALL working just fine, except for the numeric selection. Several companies start with numbers (ie. 3Com), and I would like to display all of those (0-9) when the pound symbol is clicked on.

The current query I'm using is:

					$queryCompanies = "SELECT * FROM $companies 
					WHERE hide <> 'on' AND name LIKE '".$ppr."%' ORDER BY name ASC";

The $ppr var is being sent as follows:

<a href="po_edit.php?ppr=X&po=<? echo $po; ?>">X</a> |

Would any of you have any idea how I could send the values 0 through 9 in a similar way, and how I could manipulate it to work with my current query?

Thanks much. I'm sure the above isn't terribly clear. 😉

LH

[toplay]

Try:

$queryCompanies = "SELECT * FROM $companies 
WHERE (hide != 'on') AND (name REGEXP '^[0-9]+') ORDER BY name ASC";

🙂

[Trent_Hatred]

Thanks Toplay, I'll give this a shot today and let you know how it turns out.

Mucho appreciated!

LH