Question about my query

[chornbeck]

I'm taking two pieces of form info to feed into my php process. Last Name and First Initial. The data in my MySQL table has last name and first name (entire). So when someone enters

Last Name: Brown
First Initial: C

It would return all records in the database that have the last name and a first name starting with C, so it would include Charlie, Cindy, Carl, etc...

Here is my current query, which I know is written improperly:

$result = mysql_query("SELECT * FROM owner_data WHERE LastName = '$LstName' AND

FirstName = 'FirstInitial'*")

[chornbeck]

Also, I need it to return all records that match the last name, in case someone neglects to enter their first initial...