attach is my code for search.php but i have error on line 9, can someone pleasee help me to fix it ? Thnk you

XAMPP said
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\series\insert\Search.php on line 9

line 9 code:

while($row = mysql_fetch_array($results)){

below is my full code :

$connect =mysql_connect("localhost","root","");
$query = "SELECT * FROM b_database WHERE search='". $search . "'";
while($row = mysql_fetch_array($results)){
echo $row['isbn']. "<br/>". $row['title']. "<br/>";
<form action="" method="GET">
<table style=" border:1px solid silver" cellpadding="10px" cellspacing="0px" align="center">
<tr><td colspan="4" style="background:#0066FF; color:#FFFFFF; fontsize:20px">Search Record</td></tr>
<td>Enter Search </td>
<td><input type="text" name="search" size="40" /></td>
<td><input type="submit" value="Go" /></td>

The error means your query failed. I suggest you add error checking to find out why:

$results = mysql_query($query) or die(mysql_error() . '<br/>' . $query);
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.