[klewlis]

i'm not sure if this is the right forum.... anyhoo, I am making a gateway page that is not really a part of xcart but uses some of the items out of my store. i want to display the category icons in a list, and am using this:

$strSQL = mysql_query("SELECT xcart_categories.categoryid, xcart_categories.category FROM xcart_categories, xcart_icons WHERE xcart_categories.categoryid = xcart_icons.categoryid ORDER BY order_by");
while ($row = mysql_fetch_array($strSQL))
{
     echo "<tr>\n";
     echo "<td><img src=\"icon.php?categoryid=".$row[categoryid]."&tmp=Y\" alt=\"".$row[category]."\"></td>\n";
     echo "</tr>\n";
}

and it's only showing the first one... before i added the tmp=Y it didn't even show that. am i missing something?

it is retrieving all the records and printing out the string, but the icon.php is only working on the first item.