Well I have a MySQL database of over 1254 entrys and one the columns is address.And the address are all in the kildare area (Ireland), so they all have kildare at the end of them. for example
I cant use this as it throws up almost the hole database
The words that would be put into the seach would be the last thing before kildare in my example above it is "The Curragh". any idea's on what i could do?
Kind Regards
Ciaran Mc Cann
Last edited by flatliner on Fri Jul 06, 2007 6:13 pm; edited 1 time in total
| Quote: |
| 22 Orchard Park The Curragh Co Kildare |
I cant use this as it throws up almost the hole database
| Code: |
|
// Retrieve all the data from the table $result = mysql_query("SELECT * FROM PLANNING_APPLICATIONS WHERE DEVELOPMENT_LOCATION LIKE '%$bylocation%'") or die(mysql_error());} |
The words that would be put into the seach would be the last thing before kildare in my example above it is "The Curragh". any idea's on what i could do?
Kind Regards
Ciaran Mc Cann
Last edited by flatliner on Fri Jul 06, 2007 6:13 pm; edited 1 time in total
