Selecting by first letter

[treeleaf20]

Say I have a list of restaurants and this list is changing all the time so I run a query to get all the restaurants that are in the database. I would like to have something like A-D | E-H....etc. When a user clicks on one of those links it displays restaurants where their names start with that letter. Anyone have any ideas on how to do this?

Thanks.

[thorpe]

"SELECT resturant FROM resturants WHERE resturant LIKE 'a%' OR 'b%' OR 'c%' OR 'd%'";

[sapoxgn]

if you are using mysql you can use a regular expression.. something like:

"SELECT field FROM table WHERE field REGEXP '^[a-d]'";

or something like it.. i m useless for coding regular expressions 😃

[treeleaf20]

Kind of a new problem. If I just display all of the results from the database and the results are ordered by a restaurant name. I would like to actually insert anchor links instead of selecting only a range of restaurants. Do you have an idea how to insert an anchor at A and then another one at E and so forth down the line? Also if there are no results from A-D I would like it display a message saying there are no results here. Please help.

[foid025]

Perhaps, but this is a bit slower... Make a php array and fill it with restaurant values - (just split the restaurants with something like ';;;'). Then, make a new array with only values starting with a through d, then another one with values from e-g or whatever.

This will take more time, but it will be more flexible. Cause then you can check whether there are no values, and you can display a message saying so.

[crazychris]

Did it once before here: http://www.dineout.co.nz/allresults.php