joined:Mar 25, 2006
Hi... I have a table of Kids Church songs containing approximately 200 songs. I'd like to be able to retrieve records alphabetically using the first letter of the songTitle, based on the alphabet in the URL string...
Example : www[dot]examplesite[dot]com/song.php?songIndex=A
I can't seem to get the Select statement correct.
Select * from table where substring(songTitle, 1, 0) = $songIndex order by songTitle
I'm sure it's wrong, but can someone help please?