mysql_fetch_array problem

[Jarod]

im making a links page where there are catagories and links, each links is assigned to a catagory with a number. like local bands is 1 so the catid on the row links for the the localband trendy is 1

i get this error

Anthem Online
Anthem on Mp3.com

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/www/users/shafey7s/anthemband/links.php on line 26
Localbands
Last August

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/www/users/shafey7s/anthemband/links.php on line 26

with this code

	while($row=mysql_fetch_array($linkscat))
	{
echo"$row[name]";?><br><?
		$row[id] = @mysql_query("SELECT * FROM `links` where catagory='$row[id]'") or die("Couldn't ececute query.".mysql_error());

<--error is here-->
while($row = mysql_fetch_array($row[id]))
<--->
	{
	?>
	<a href="<?echo $row[links];?>" class="text12"><?echo $row[text];?> </a>
	<br /><br />
	<?
	}
}

[tomhath]

Yes, the error is right where you say :eek:

Is variable $row an array that holds the resource, or an array that holds the fields from one row?

You need to pick another variable name for one or the other.

while($row = mysql_fetch_array($row[id]))