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]
