Syntax error help

[mishasoni]

PHP newbie here -

 

I am getting the following sql syntax error:

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'begins with B ORDER BY NameLast ASC LIMIT 0, 30' at line 1"

 

I believe this error is referring to the below section of code:

 

if (isset($_GET['firstletter'])) {

  $firstletter = $_GET['firstletter'];

}

 

$query_rsParticipants = "SELECT * FROM Contacts WHERE ContactType = 'Scientist' AND ContactID_pk <> 0 AND NameLast begins with $firstletter ORDER BY NameLast ASC";

 

 

 

Can anyone tell me what the error is? 

 

 

 

[revraz]

The error is "begins with"

 

Try LIKE instead.

 

 

[mishasoni]

I should clarify what I am trying to do.  $firstletter = either A, B, C, D...etc. I want to filter records alphabetically by NameLast, so that, for example, only last names beginning with "B" are shown. Thanks.

[DarkWater]

$query_rsParticipants = "SELECT * FROM Contacts WHERE ContactType = 'Scientist' AND ContactID_pk <> 0 AND NameLast LIKE '$firstletter%' ORDER BY NameLast ASC";

 

That should be your query.

[mishasoni]

Thank you!