Hey guys.
I'm trying to make a simple page that will query a mysql table for names of films.
I have most of it done however when you click on the letter, it shows all of the results with the letter in the name, I want it to show results that BEGIN with the letter, it's hard to explain but...
Here's the page
Here's the line;
I just pretty much need to know the syntax or whatever they're called to find it if it begins with the $letter.
I'm trying to make a simple page that will query a mysql table for names of films.
I have most of it done however when you click on the letter, it shows all of the results with the letter in the name, I want it to show results that BEGIN with the letter, it's hard to explain but...
Here's the page
Here's the line;
Code:
$sql="SELECT Name FROM films WHERE Name [COLOR=Red]LIKE[/COLOR] '%" . $letter . "%'";I just pretty much need to know the syntax or whatever they're called to find it if it begins with the $letter.
