> 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?
Well, the order you get things from the database really has nothing to
do with the order you display things on the screen. Naturally, the
order in which the $DatabaseRow is parsed does matter. This means, you
are welcome to move around the various fields in the query, as long as
you remember to rearrange the fields in the code that parses the
$DatabaseRow.
Cheers,
-jj
--
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]
