Yeah, like he said (sorry Ralph, I started composing my email right
before yours came in).
-jj
Ralph Guzman wrote:
>
> You should have something that looks like this:
>
> $Query = "SELECT Name, Author, Description, Keywords, Thumbnail, Graphic,
> LargeGraphic, DisplayPrecedence, Active, Author";
> $Query .= "FROM item";
> etc...
>
> $itemName = $DatabaseRow[0];
> $itemAuthor = $DatabaseRow[1];
> $itemDescription = $DatabaseRow[2];
> $itemKeywords = $DatabaseRow[3];
> $itemThumbnail = $DatabaseRow[4];
> $itemGraphic = $DatabaseRow[5];
> $itemLargeGraphic = $DatabaseRow[6];
> $itemDisplayPrecedence = $DatabaseRow[7];
> $itemActive = $DatabaseRow[8];
>
> The order of fields in table is irrelevant, it's dependant on what you
> specify in field.
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Shawn
> Sent: Monday, August 14, 2000 7:42 PM
> To: FreeTrade
> Subject: [FreeTrade] Positioning new elements in admin_item
>
> Hello All;
>
> I have just added a new field to one of my tables, and thanks to the How-To
> I got from Shannon I now have all the various screens working great, and my
> new "Author" category works.
> One question though, how do you get around the specific requirements of
> MySQL in relation to order and positioning? What I mean is this, the new
> field is database row 8, but in the admin_item screen I want it to show as
> the second item, under database row 0 (which is name), whenever I do this
> the most of the data ends up in the wrong fields, I have tried rearainging
> the various elements in the code but without success.
> This is the code as it works.
>
> $item = intval($item);
> $Query = "SELECT Name, Description, Keywords, Thumbnail, Graphic,
> LargeGraphic, DisplayPrecedence, Active, Author ";
> $Query .= "FROM item ";
> etc
>
> and also a litle bit further down
>
> $itemName = $DatabaseRow[0];
> $itemDescription = $DatabaseRow[1];
> $itemKeywords = $DatabaseRow[2];
> $itemThumbnail = $DatabaseRow[3];
> $itemGraphic = $DatabaseRow[4];
> $itemLargeGraphic = $DatabaseRow[5];
> $itemDisplayPrecedence = $DatabaseRow[6];
> $itemActive = $DatabaseRow[7];
> $itemAuthor = $DatabaseRow[8];
>
> /* this part is below the "Active" entry.*/
>
> print("<TR><TD>" . L_ADMINITEM_AUTHOR . "</TD>\n");
> print("<TD><INPUT TYPE=\"text\" NAME=\"inputAuthor\" SIZE=\"32\" ");
> print("VALUE=\"" . prepareText($itemAuthor) . "\"></TD></TR>\n");
>
> Is there anyway that an item such as "Author" can be moved to a different
> location?
>
> Shawn
>
> ------------------------------------------------------------
> 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]
--
if (shannon - jj) * behrens == webEngineer["CLEAR INK�"]:
print "<i>imagination is the only real medium(sm)</i><br>"
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
