Display by letter

[simjay]

example: $letter = a

<?
$sql = "SELECT * FROM name WHERE *****first letter = $letter *****";
$result = mysql_query($sql, $conn) or die(mysql_error());
while ($newArray = mysql_fetch_array($result)) {
$name = $newArray['name'];

echo "$name *<br>";
}
?>

I am trying to make a script so i can display a list of name beging with the letter *.

Any help would be great.

[iLLin]

$sql = "SELECT * FROM name WHERE first letter = '%".$letter/"';


That will return all results with the name that begins with "a";

[simjay]

sorry but its not liking that?

[simjay]

this is what i have


$sql = "SELECT * FROM user ORDER BY user_name WHERE user_name = '%".$letter/"'";

[iLLin]

im sorry


$sql = "SELECT * FROM name WHERE first letter LIKE '%".$letter."';


Notice the LIKE

[iLLin]

and the slash was a typo, should have been a period

[simjay]

still not working sorry, are the speach marks right?

[iLLin]

sql = "SELECT * FROM user WHERE user_name LIKE '%".$letter."' ORDER BY user_name";

[simjay]

no work, lol im getting ready to give up with this, lol

[iLLin]

Im sucking today


sql = "SELECT * FROM user WHERE user_name LIKE '".$letter."%' ORDER BY user_name";


The percent should be at the end.

[simjay]

yay, lol
thank you so much