X-Cart forums - displaying icons

X-Cart forums (https://forum.x-cart.com/index.php)

- Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)

- - displaying icons (https://forum.x-cart.com/showthread.php?t=3331)

displaying icons

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:

Code:

$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.

hrm... i think something else weird is going on too... because when i add a subcategory to one of the main categories, the main category image doesn't show up in the store as it should....

any ideas?

the images on my products aren't working either. it just doesn't display anything, and doesn't save (when i go back in to modify again, it's set back to the default "no image").

is this a bug? does anyone have the fix?