Member Avatar for php_coder

Hi
I am trying to search the entire table (all the columns) for a search term. But am getting mysql error

$data = "SELECT * FROM songmaster WHERE songTitle like '".$find."' and mp3File like '".$find."'";

//And we display the results
while($result = mysql_fetch_array($data))
{
echo "<font face='Verdana' size='4' color=red>".$result;
echo "<br>";
echo "<font face='Verdana' size='4' color=red>".$result;
}

any help please?

  • 2 Contributors
  • 1 Reply
  • 59 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by Puckdropper
Member Avatar for Puckdropper

What is your error message?

My psychic debugging skills are weak, but I'm getting a feeling you need to run mysql_query() before mysql_fetch_array().

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.