Member Avatar for jyotidagia

could someone point out the error in the followin php/mysql code

$strSearchVal = $_GET['q'];
//database connection..
//...

$strSQL = "SELECT DISTINCT area FROM hospital where area like '%'+ $strSearchVal; ";
$result = mysql_query($strSQL);

while ($arrThisRow = mysql_fetch_array($result )) {
 echo '<li>' . $arrThisRow['area'] . '</li>';
Edited by peter_budo because: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)
  • 2 Contributors
  • 1 Reply
  • 70 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas 
$strSQL = "SELECT DISTINCT area FROM hospital where area like '%$strSearchVal' ";
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.