X-Cart forums

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

[klewlis]

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?

[klewlis]

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?

[klewlis]

anyone?