$query="SELECT * FROM table where the first name starts with $letter";

How would you do this?

Want all the entries in database, that all the $name starts with "A",
for example...

Andy George wrote:

> $query="SELECT * FROM table where the first name starts with $letter";
>
> How would you do this?
>
> Want all the entries in database, that all the $name starts with "A",
> for example...
"SELECT * FROM table where column_name like 'A%'";

Not case-sensitive.
Mick

> "SELECT * FROM table where column_name like 'A%'";


....works a treat, cheers muchly...