Search MySql table?

Original - php Code <? $query = "SELECT * FROM table WHERE somefield like '%$userInput%'"; $result = mysql_query($query); $num_rows = mysql_num_rows($result); if($num_rows == 0) { echo "No results<BR>n"; } else { while($row = mysql_fetch_array($result)) { echo "{$row['somefield']}<BR>n"; } } ?>

<?
$query = "SELECT * FROM table WHERE somefield like '%$userInput%'";
$result = mysql_query($query);
$num_rows = mysql_num_rows($result);
if($num_rows == 0) {
  echo "No results<BR>n";
} else {
 while($row = mysql_fetch_array($result)) {
   echo "{$row['somefield']}<BR>n";
 }
}
?>