mysql_fetch_array() error

[micmac]

Hi all,
Can anyone see why the following code is generating errors in relation to mysql_fetch_array($result)

Here is the script:

<?

$sql = "SELECT * FROM company_categories,cat1 WHERE company_categories.CatID=cat1.CatID WHERE company_categories.company_id='$company_id'";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)){

$cat_id = $row["CatID"];
$cat_name = $row["CatName"];




?>     

<tr>
    <td><input name="" type="text" value="<? echo $cat_name ?>">
                                    <br>
                                    <br>
                                  </td>

  </tr>

 <?
}
?> 

Cheers,
micmac

[anthill]

think its your sql query there:

1) your trying to query two databases or something or other (company_categories,cat1) which i dunno about the majority, but never works for me

2) also, should you be saying

$sql = "SELECT * FROM company_categories,cat1 WHERE company_categories.CatID=cat1.CatID AND company_categories.company_id='$company_id'";

instead. Try adding:

echo mysql_error();

and see what it gives you.