please check

[narjis]

 

i'm running a simple query of LIKE SELECT statment but it says boolean resource given to mysql_fetch_assoc parameter 1 Here is my code

$sql = "SELECT `city` FROM `cities` WHERE `city` LIKE '$search_term%'";
$result = mysql_query($sql);
//echo ($sql);
//if
while($row=mysql_fetch_assoc($result)){
echo ("<li>".$row['cities']."</li>");
}

please check my $sql statement is it wrong?

Where?

[Pikachu2000]

If you're getting that error message, apparently something is wrong with the query. I'll bet mysql_error would have produce some useful information to help solve this, so echo it and echo your query string to make sure it contains the values you'd expect it to contain.