Mysql/PHP Search parameter help

[DaviDJ]

Well it's a PHP/MySQL problem and so I thought it would be best in here.  Well the thing is on phpMyAdmin I do a query and it returns the correct result... but when I do it in php the result is 0.

[code]
  // Select all members
$sql = "SELECT `id`
      FROM `".$GLOBALS['DB_PREFIX']."_members`
      WHERE `rank` NOT LIKE 'admin'
      AND `locked` = 'N';";
$res = mysql_query($sql) or page_end('Error in sql.');
unset($sql);
$total_mem = mysql_num_rows($result);
mysql_free_result($result);
[/code]

I tried != in replace of NOT LIKE but $total_mem still returned 0, whereas phpMyAdmin returns the correct number of results.

I thank you to anyone who can help me on this, and any extra info you need just ask.

Thanks, Rhinos

[fenway]

But you're not getting an error?

[DaviDJ]

Thanks, but I have fixed the problem now... just took time to look it over.