first time user - mysql database and html pages

[pendle666]

Hello

I hope I'm in the right forum for this - as the header says, I'm a complete beginner when it comes to mysql.

My database has fields for name and surname which the user can enter something in one or both.

I also have a placenames dropdown option

<option value="LON">London</option>
<option value="MAN">Manchester</option>
<option value="LEE">Leeds</option>

however when one of these placenames is selected, the search ignores it.

So if someone chooses John Smith Manchester - all the John Smiths are listed, but in all cities, not just Manchester.

I'm not sure what to do - can anyone help?

regards

Pendle

 

[r937]

the problem is most likely in the way you are constructing the query statement from the form fields

therefore this question is more appropriate for the forum for your particular application language (php?)

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[pendle666]

Hi

Thanks for your reply. I've managed to resolve the problem now- everything was in lower case and needed to be in upper case as that's how my data is put in the database.

regards

Pendle