Keyword Search

[Dysan]

Hi,

Why doesn't the following code work? If you enter valid keywords inside the form, nothing gets returned. Why is this?

if(isset($_GET['keyword']))
{
  $keyword = mysql_real_escape_string($_POST['keyword']);
  $result = mysql_query("SELECT * FROM music WHERE artist LIKE '%$keyword%'");
  if(mysql_num_rows($result))
  { 
    while($row = mysql_fetch_array($result))
    {
  	  echo "Keyword Search";
    }
  }
}

<form name="form1" method="post" action="search.php">
  <input name="keyword" type="text" id="keyword">
  <input type="submit" name="Submit" value="Submit">
</form>

[dagon]

post not get on your set check

[bradgrafelman]

Just to clarify, this is where your problem is:

if(isset($_GET['keyword']))

You POST'ed data, yet you're using the $_GET array there.