Search Script not working...
ok, i got this off of a tutorial as well. it seems thoes scripts are old :p
it gives me the following error:
Code:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/home/homtek/public_html/dclamp/results.php on line 15
Here be the code:
PHP Code:
<html>
<head>
<title>Search Results</title>
</head>
<body>
<h2>Search Results</h2>
<br>
<?
$dbh=mysql_connect ("localhost", "homtek_dclamp", "moiola");
mysql_select_db ("homtek_HomTekSQL1");
$query = "SELECT * FROM users WHERE user LIKE '%".$name."%'";
$result = mysql_query($query);
while ($record = mysql_fetch_assoc($result)) {
while (list($fieldname, $fieldvalue) = each ($record)) {
echo $fieldname.": <b>".$fieldvalue."</b><br>";
}
echo "<br>";
}
?>
<br>
<a href="search.html">Click here to go back to the search page</a>
</body>
</html>
it starts on: http://dclamp.homtek.net/search.html
Re: Search Script not working...
You have a query error or zero result set.
Use mysql_error() to get the error message.
PHP Code:
$result = mysql_query($query);
if (!is_resource($result))
die(mysql_error());
Don't use die() in a production situation though.
