exhaler Posted February 3, 2009 Share Posted February 3, 2009 hi, newbei here. just a quick question. i have a database filled with names and created a php page that displays them according to letter asc. for example hyperlink for letter A is <a href = "listrestaurant.php?letter=A"> also in php i use this command to fetch all the names that start with A "SELECT * FROM restaurant WHERE name LIKE'{$letter}% ORDER BY name ASC "; this works fine if the name begins with a letter but some names begin with a number, how can i create a page to show only the names that start with a number if i click on a link <a href = "listrestaurant.php?letter=#"> thx Quote Link to comment Share on other sites More sharing options...
sasa Posted February 3, 2009 Share Posted February 3, 2009 WHERE name<'A' Quote Link to comment Share on other sites More sharing options...
exhaler Posted February 3, 2009 Author Share Posted February 3, 2009 thx that worked perfectly Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.