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]

Reply via email to