Search-no-listings not working 2007-12-01 - By Muthukumar Selvarasu
Back
Hi David,
First you have to ensure your side which version of Mysql you are using.
If you are using mysql 4.x then your query right; but make sure you
condition as " authorid = author.id " is correct table fields and joketext
LIKE '*%'. If its right then should work in mysql 4.x
First check with joketext LIKE '%***%'
then
If you are using mysql 5.x then you have to alter your query to satisfy
mysql 5.x query standard.
If 5.x then change you query as
'SELECT joketext, name, email
FROM joke left out join author on joke.authorid = author.id where joke
jokedate >="2004-04-01"' .
'AND joketext LIKE "w%"');
or
'SELECT joketext, name, email
FROM (joke , author) Where joke.authorid = author.id and joke .jokedate
>="2004-04-01"' .
'AND joketext LIKE "w%"');
For your reference check mysql 5 query standards.
Hope you will understand the issue and will make your query perfect.
Thanks,
Muthukumar Selvarasu,
Project Manager (Web Development),
Webmaster Ltd.
-- --Original Message-- --
From: grovesdavid@(protected)
[mailto:grovesdavid@(protected)]
Sent: Saturday, December 01, 2007 10:42 PM
To: win32@(protected)
Subject: Search-no-listings not working
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=muthukumar_se@(protected)
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql@(protected)
|
|
