Page is a not externally linkable
- Code, Content, and Presentation
-- PHP Server Side Scripting
---- Using PHP to search an entire column contents in MySQL


Air - 7:50 pm on Nov 8, 2001 (gmt 0)


Ok, try it like this:

$db = mysql_connect("localhost","userid","password") or die(mysql_error());
mysql_select_db("databasename",$db) or die(mysql_error());

$query = "SELECT * FROM tablename WHERE city_service LIKE \"%$form_city%\" ORDER BY last_name";
$result = mysql_query("$query") or die(mysql_error());
$row = mysql_fetch_array($result, MYSQL_ASSOC);

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
print "<b>$form_city</b> -- $row[city_service] $row[last_name]<br>\n";
}


Thread source:: http://www.webmasterworld.com/php/351.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com