Trouble with mysql_fetch_array();

mantako · 30th December 2003, 01:23 PM

I'm getting this error message:

Quote:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/www/cms/function_lib.php on line 34

This is my code:

Code:

$sql="SELECT name FROM cms_categories";
$cats=mysql_query($sql);
$cat_array=mysql_fetch_array($cats);

I've already tried checking my DB connection and rearranging my query. :cry:

**Mr. Tech** · 31st December 2003, 08:36 AM

That is annoying! Try this function:

mysql_fetch_assoc();

buchard · 5th March 2004, 12:03 AM

Your query:

$sql="SELECT name FROM cms_categories";

You should change this to (for example):

$sql="SELECT name FROM cms_categories where catid='2'";

You forgot the logic condition "where ......."

hope it's help u :wink: