Help with simple search query

[Talguy]

I am trying to create a simple search query to find if a name exist in my mysql db.

what I have so far

$sql = "SELECT category_name FROM gallery_category WHERE category_name = '".$category_name."'";

if(mysql_query($sql) == $category_name)
{
  do not create directory
}
else
  create directory

[mjax]

Try this:

$sql = "SELECT category_name FROM gallery_category WHERE category_name = '".$category_name."'";

if(mysql_result(mysql_query($sql), 0) == $category_name)
{
  do not create directory
}
else
  create directory

[Talguy]

I got it a used a mysql_num_rows and said if it is less then one creat else don't create

thanks mjax ur code sparked my memory