 | | | Second Error Measge not working.... | Second Error Measge not working.... 2007-11-29 - By -not available-
Back
Hello,
I'm trying to build an Estate Agents search, but keep finding silly errors
I'm making. Here's one
<html>
<head>
<title></title>
</head>
<body>
<?php
$dbcnx = @(protected)('localhost', '#', '');
If (!$dbcnx) {
echo '<p>Unable to connect to database at this time</p>';
exit();
}
mysql_select_db('ijdb', $dbcnx);
If (!@(protected)('ijdb')) {
exit('<p>Unable to locate the joke db at present try later</p>');
}
?>
<p>Here is a list of our jokes</p>
<blockquote>
<?php
$result = @(protected)('SELECT id LEFT (joketext, 20) FROM joke WHERE
jokedate >= "2004-05-11"' . 'AND joketext LIKE "%HELLO%"' );
If (!$result) {
exit('<p> Error performing query: ' . mysql_error() . '</p>');
} else {($result == 0)
echo '<p> We are sorry no jokes match your search criteria! </p>';
}
while ($row = mysql_fetch_array($result)) {
echo '<p>' . $row['joketext'] . '</p>';
}
?>
</blockquote>
</body>
</html>
The error measage relates to this: else {($result == 0)
echo '<p> We are sorry no jokes match your search criteria! </p>';.
There will be two occasions when the search would fail in real life:
1 db error
2 No properties match search criteria.. This is the one I'm having problems
with ....
Kind Regards
G)
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql@(protected)
|
|
|