Michael,
Tried the code and it worked like a charm! Thanks bunches to you and
everyone else who responded! (I left the code in my reply in case anyone
missed it)
Alan
> > I'm looking over the FT code and I've seen in the admin screen
> when adding
> > attributes and variations, there is a field for defining a graphic for a
> > attribute or variation. I thought this would be a great way to
> have a color
> > swatch display for each variation. However, I can't find anything in the
> > code that would let me do anything with this graphic. Has
> anyone done this?
> > If so, a code snippet to test this out would be greatly appreciated. :-)
>
> I asked this same question about a month and a half ago...Leon's
> answer...code it in :-))
>
> * ugly hack about to follow :-)) *
>
> In the "item" file from the "screens" directory I added a query
> just below the " //get list of attributes as comma-separated list"
> query.
>
> I stuck in this hack to grab the image and display it.
>
> //get full variation info
> //hack add query for variation image
> $Query2 = "SELECT a.ID, a.Name, v.ID, v.Name, v.Graphic ";
> $Query2 .= "FROM sku_variation sv, variation v, attribute a ";
> $Query2 .= "WHERE sv.SKU = " .
> $Item["SKU"]["ID"][$index] . " ";
> $Query2 .= "AND sv.Variation = v.ID ";
> $Query2 .= "AND v.Attribute = a.ID ";
> $Query2 .= "AND a.ID in ($MultiAttributes) ";
> $Query2 .= "ORDER BY a.DisplayPrecedence, a.Name ";
> $DataResult = mysql_query($Query2, $DatabaseLink);
>
> while($DataRow = mysql_fetch_row($DataResult))
> {
>
> //hack add query for variation image
> $tVariationGraphic = $DataRow[4];
>
> if($tVariationGraphic != "") {
> echo "<img
> src=\"images/items/$tVariationGraphic\" align=\"middle\"
> hspace=\"0\" vspace=\"0\">\n";
> }
> else
> {
> echo "\n";
> }
> }
>
>
> - hope this helps -
>
> --
>
> best regards
> -michael
>
> Michael Chopek <[EMAIL PROTECTED]>
> Down to Earth Development Ltd - http://www.d2earth.com/
> Website & Web Applications Development
> Selena Sol's WebWare Mail List - http://www.d2earth.com/mail_list.html
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Site: http://www.working-dogs.com/freetrade/
> Problems?: [EMAIL PROTECTED]
>
>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
