On Thu, 2008-10-23 at 19:30 -0700, Ryan S wrote:
> Hey all,
> Was wondering how this is done, have a bunch of links like so:
> 0-9 : a : b : c -----> till Z
>
> these will be linked to the program (so far have done this) but when the user
> clicks any of those links I want to query the DB for just the first alphabet
> from the field "title", using LIKE is not working for me because its catching
> alphabets from the middle of the word as well.
You're using like wrong... you want to use it with one %...
where foo like 'a%'
> Also how to do 0-9? do i have to have 10 if() conditions for that?
Maybe you could add a new field to the table and set it to the first
character of the field or 0 if it's a digit. Then you can index it and
not use "like" or multiple conditions to match digits.
Cheers,
Rob.
--
http://www.interjinn.com
Application and Templating Framework for PHP
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
