search query and results
Posted: Wed Jan 16, 2008 11:11 am
Hi, could someone look at the bebelow code and help me fixing the error message?
I have a page with one text field to search and a php script to show the results.
and I get the following error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/giustinianinicola.com/httpdocs/contacts/search.php on line 28
Many Thanks
Nic
I have a page with one text field to search and a php script to show the results.
and I get the following error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/giustinianinicola.com/httpdocs/contacts/search.php on line 28
Code: Select all
<html>
<body>
<form name="search" method="POST" action="search.php">
<p>Search: <input name="search" type="text" id="search">
<p><input type="submit" name="submit" value="submit">
</form>
</body>
</html>Code: Select all
<?
$host = "localhost";
$user = "******";
$pass = "******";
$dbname = "contacts";
$connection = mysql_connect($host,$user,$pass) or die (mysql_errno().": ".mysql_error()."<BR>");
mysql_select_db($dbname);
$result = mysql_query("SELECT * FROM contacts where search=" . $_POST['search'] ."'");
echo "<table border=0 width=1400>
<tr bgcolor=#87ceeb>
<td width=100><b>First Name</td><td width=100><b>Last Name</td>
<td width=100><b>Company Name</td><td width=100><b>Website</td>
<td width=100><b>Street + Number</td><td width=100><b>City</td>
<td width=100><b>Post Code</td><td width=100><b>Country</td>
<td width=100><b>E-Mail 1</td><td width=100><b>E-Mail 2</td>
<td width=100><b>Phone</td><td width=100><b>Mobile</td>
<td width=100><b>Christmas Card</td><td width=100><b>Birthday</b></td>
</tr>";
while($row = mysql_fetch_array($result)) {
echo "<tr bgcolor=#4682b4>";
echo "<td><font color=#FFFFFF>" . $row['first_name'] . "</td>";
echo "<td><font color=#FFFFFF>" . $row['last_name'] . "</td>";
echo "<td><font color=#FFFFFF>" . $row['company_name'] . "</td>";
echo "<td><font color=#FFFFFF>" . $row['website'] . "</td>";
echo "<td><font color=#FFFFFF>" . $row['street'] . "</td>";
echo "<td><font color=#FFFFFF>" . $row['city'] . "</td>";
echo "<td><font color=#FFFFFF>" . $row['zip'] . "</td>";
echo "<td><font color=#FFFFFF>" . $row['country'] . "</td>";
echo "<td><font color=#FFFFFF>" . $row['mail1'] . "</td>";
echo "<td><font color=#FFFFFF>" . $row['mail2'] . "</td>";
echo "<td><font color=#FFFFFF>" . $row['phone'] . "</td>";
echo "<td><font color=#FFFFFF>" . $row['mobile'] . "</td>";
echo "<td><font color=#FFFFFF>" . $row['card'] . "</td>";
echo "<td><font color=#FFFFFF>" . $row['birthday'] . "</font></td>";
echo "</tr>";
}
echo "</table>";
?>Nic