Search-no-listings not working 2007-12-01 - By -not available-
Back
Hello,
Part of the script:
$jokelist = mysql_query(
'SELECT joketext, name, email
FROM joke, author WHERE authorid = author.id AND jokedate >="2004-04-01"' .
'AND joketext LIKE "w%"');
If (!$jokelist) {
exit('<p> error performing search: ' . mysql_error() . '</p>');
} elseif ($jokelist == 0) {echo 'Sorry no jokes matched your search';
} else while ($joke = mysql_fetch_array($jokelist)) {
$joketext = $joke['joketext'];
$name = $joke['name'];
$email = $joke['email'];
echo "<p>$joketext<br />" .
"(by <a href='mailto:$email'>$name</a>)</p>";
}
?>
This part of the above query doesn't work:
elseif ($jokelist == 0) {echo 'Sorry no jokes matched your search';
WHY?
While I'm here, there is one other question, I'm trying to add a delete
button next to each item listed, but can't work out how to do it....
David)
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql@(protected)
|
|
