I think the code looks fine... my server doesnt agree
| From: | Tim | Date: | Mon, 09 Jul 2001 04:47:31 +0000 |
| Subject: | I think the code looks fine... my server doesnt agree | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10169@lists.php.net to get a copy of this message | ||
I think that the following code looks fine, but I get an error (Warning:
Supplied argument is not a valid MySQL result resource) where it says "while
($Row = mysql_fetch_array ($Result)) {" any ideas?
<?php
$Link = mysql_connect ($Host, $User, $Password);
$title = trim($title);
$title2 = ereg_replace (" ", " %' || like '% ", $title);
if ($category) {
$Query = "SELECT * from $TableName WHERE ((category)=$category)";
print "Your search query of <b> $category </b> returned the following
results:<br><br>";
} else { if ($title) {
$Query = "SELECT * from $TableName WHERE title LIKE '%$title2%' ";
print "Your search query of <b> $title </b> returned the following
results:<br><br>";
}
}
if ($category = "") {
print "";
}
$Result = mysql_db_query ($DBName, $Query, $Link);
while ($Row = mysql_fetch_array ($Result)) {
print "<a href=item.php?p=$Row[id]>";
echo ( $Row[title] );
print "</a><br>";
}
mysql_close ($Link);
?>