MYSQL search help

[All4172]

I"m attempting to search MYSQL and if the field keyword has a term that matches the user's keyword, it will display a message saying SORRY KEYWORD ALREADY EXISTS.  So far I'm having no luck.  Here's what I have so far but doesn't work:

[code]
$keyword = $_REQUEST['keyword'];
$result = mysql_query("SELECT * FROM joa
WHERE keyword LIKE '%$keyword%''");

if (isset($result)){
echo "Keyword exists";}
else {
echo "Keyword doesn't exist";}

[/code]

Any advice would be appreciated :)

[indalecio]

[code]$result = mysql_query("SELECT * FROM joa
WHERE keyword LIKE '%$keyword%' >>'<< ");[/code]
The little ' in between then >> << doesn't belong.

[All4172]

Good eye ;)

So far though doesn't seem to solve it.  As it is above minus the ', it still returns exists whether the keyword is int he mysql db or not :(

[Chips]

[quote author=All4172 link=topic=99489.msg391793#msg391793 date=1152086415]
I"m attempting to search MYSQL and if the field keyword has a term that matches the user's keyword, it will display a message saying SORRY KEYWORD ALREADY EXISTS.  So far I'm having no luck.  Here's what I have so far but doesn't work:

[code]
$keyword = $_REQUEST['keyword'];
$result = mysql_query("SELECT * FROM joa
WHERE keyword LIKE '%$keyword%''");

if (isset($result)){
echo "Keyword exists";}
else {
echo "Keyword doesn't exist";}

[/code]

Any advice would be appreciated :)
[/quote]
Could try (until someone who's better comes along) this:
[code]
if (mysql_num_rows($result) > 0) {
echo "Keyword exists";
} else {
echo "Keyword doesn't exist";
}
[/code]
and see if that works instead...

[All4172]

[quote]
Could try (until someone who's better comes along) this:
[code]
if (mysql_num_rows($result) > 0) {
echo "Keyword exists";
} else {
echo "Keyword doesn't exist";
}
[/code]
and see if that works instead...
[/quote]

Thanks :)  That works like a charm.