SQL help??

Ashleek007 · September 13th, 2004, 01:43 PM

ive got a web page where i want to display records from my SQL database in alphabetical categories.

I select a letter from a drop down menu, click find records and then a list of records begining with the chosen letter are displayed.

does anyone kno the SQL code i need to use to get this information

so far ive got

$letter = $_POST['letter'];
$query = "SELECT * FROM dbname WHERE name LIKE '[$letter]'";

any ideas
Thanks
ASH:D

richard.york · September 13th, 2004, 03:06 PM

You're very close.

Code:

$query = "SELECT * FROM dbname WHERE name LIKE '[$letter]%'";

You want the wildcard character after the variable for the letter to signify that the field must begin with the character. Then you'd want to append an ORDER BY clause.

Code:

$query = "SELECT * FROM dbname WHERE name LIKE '[$letter]%' ORDER BY name ASC";

HTH!

Regards,
Rich

--
[http://www.smilingsouls.net]
[http://pear.php.net/Mail_IMAP] A PHP/C-Client/PEAR solution for webmail