Jump to content

Archived

This topic is now archived and is closed to further replies.

All4172

MYSQL search help

Recommended Posts

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 :)

Share this post


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

Share this post


Link to post
Share on other sites
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 :(

Share this post


Link to post
Share on other sites
[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...

Share this post


Link to post
Share on other sites
[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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.