[lee sands]

	print '<div class="small-border"><ul>';
		$sql = "SELECT * FROM cms_catergories";
		$result = mysql_query($sql,$conn);
		
		while($row = mysql_fetch_array($result)) {
			print '<li> <a href = "catergoy.php?c='.$row['cat_id'].'">'.$row['cat_name'].'</a></li>';
		}
		print '</ul></div>';

this code works fine on its own but when imported it shows

Quote

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\cms\library\cats.php on line 8

[webdesigner93]

lee sands, on 14 January 2012 - 02:31 PM, said:

	print '<div class="small-border"><ul>';
		$sql = "SELECT * FROM cms_catergories";
		$result = mysql_query($sql,$conn);
		
		while($row = mysql_fetch_array($result)) {
			print '<li> <a href = "catergoy.php?c='.$row['cat_id'].'">'.$row['cat_name'].'</a></li>';
		}
		print '</ul></div>';

this code works fine on its own but when imported it shows

try seeing what $result outputs

echo var_dump($result);

[GalaxyTramp]

lee sands, on 14 January 2012 - 02:31 PM, said:

	print '<div class="small-border"><ul>';
		$sql = "SELECT * FROM cms_catergories";
		$result = mysql_query($sql,$conn);
		
		while($row = mysql_fetch_array($result)) {
			print '<li> <a href = "catergoy.php?c='.$row['cat_id'].'">'.$row['cat_name'].'</a></li>';
		}
		print '</ul></div>';

this code works fine on its own but when imported it shows

The error code shows that the problem lies with line 8 of the cats.php page. Which line of your code is this?

Not sure what you mean when you say "this code works fine on its own but when imported it shows" the error.

Your problem is that your query is failing so I would suspect that the $conn variable is incorrect on the "imported" machine.

Add $result = mysql_query($sql,$conn)or die('There has been an error' . mysql_error()); to your query to get exact error

Colin

[lee sands]

all sorted it was a pice of code that was not being showed lol i have a new problem with mysql joins