 | | | Second Error Measge not working.... | Second Error Measge not working.... 2007-11-29 - By Price, Randall
Back
Not sure about this but the syntax error may be from a missing space
between:
"2004-05-11"AND
which may need to be:
"2004-05-11" AND
Hope this helps,
Randall Price
Secure Enterprise Technology Initiatives
Microsoft Implementation Group
Virginia Tech Information Technology
1700 Pratt Drive
Blacksburg, VA 24060
Email: Randall.Price@(protected)
Phone: (540) 231-4396
-- --Original Message-- --
From: Randy Clamons [mailto:randy@(protected)]
Sent: Thursday, November 29, 2007 1:12 PM
To: grovesdavid@(protected)
Cc: win32@(protected)
Subject: Re: Second Error Measge not working....
G,
The problem again is with your query. You have written this:
'SELECT id LEFT (joketext, 20) FROM joke WHERE jokedate >= "2004-05-11"'
. 'AND joketext LIKE "%HELLO%"'
This will look like this when interpolated:
SELECT id LEFT (joketext, 20) FROM joke WHERE jokedate >=
"2004-05-11"AND joketext LIKE "%HELLO%"
It's actually surprising that you get any successful results. Columns
must be separated by a comma, and you won't get andy data for
$row['joketext']. Try this:
SELECT id, LEFT (joketext, 20) AS joketext FROM joke WHERE jokedate >=
"2004-05-11"AND joketext LIKE "%HELLO%"
Now, I'm no php expert, but I have a little experience. Your logic
structure probably isn't doing what you thought it would.
Here's your code:
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>';
}
It looks to me like you will always get the 'no jokes' message, even
when jokes are listed later on the page. You probably meant this:
if (!$result) {
exit('<p> Error performing query: ' . mysql_error() . '</p>');
}
elseif ($result == 0){
echo '<p> We are sorry no jokes match your search criteria!
</p>';
}
else {
while ($row = mysql_fetch_array($result)) {
echo '<p>' . $row['joketext'] . '</p>';
}
}
The indentation is not necessary, but it does make it easier to read.
Randy Clamons
Systems Programming
randy@(protected)
grovesdavid@(protected) wrote:
> 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=Randall.Price@(protected)
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql@(protected)
|
|
|