FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


*solved*





flatliner
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
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
flatliner
Problem fixed, just a litte typo on an if statment and the hole thing got throw off.
Related topics
Can one reset the site? (Solved)
A great website poll....
solved
[Solved] [Java] KeyListener Not Working In Internet Explorer
Untaring files in DirectAdmin [SOLVED]
New Domain -Solved-
Flash not working on Firefox
Math Problem. 30 frih. (Solved!)
Tabless layout - footer problems - [solved]
frihost serv2 and joomla = problem :( SOLVED
"Document not found" in iframe
PICASA LABELS/ALBUMS! [SOLVED]
[solved]show / hide table row. Something is wrong
Pro Tools Website
PHP + GD coder needed - Dynamic Sig Help {SOLVED}
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.