Professional Web Applications Themes

DW Php update form where one field is menu from another table - PHP Development

I'm using Dreamweaver's "Update Record" form wizard to create a record update page. Most of the fields are "text", one is "file" and I want one of them to be a "menu". The "menu" field should be populated with the fields of another table. Here's the problem... If I leave all of the fields as text input fields, the form works fine. But, as soon as I change the "manufacturers" field to a drop-down menu populated with entries from another table, I get the following error when accessing the page... P error: p error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' ...

  1. #1

    Default DW Php update form where one field is menu from another table

    I'm using Dreamweaver's "Update Record" form wizard to create a record
    update page. Most of the fields are "text", one is "file" and I want one of
    them to be a "menu". The "menu" field should be populated with the fields
    of another table.

    Here's the problem... If I leave all of the fields as text input fields,
    the form works fine. But, as soon as I change the "manufacturers" field to
    a drop-down menu populated with entries from another table, I get the
    following error when accessing the page...

    P error: p error, expecting `T_STRING' or `T_VARIABLE' or
    `T_NUM_STRING' in
    /home/s/k/user992816/html/RobesonWeb/admin/adminEditSpecials.php on line
    106

    line 106 reads...

    <option value="<?php echo $row_rs_RobesonWebManufacturer['manufacturer']?>"
    <?php if (!(strcmp($row_rs_RobesonWebManufacturer['manufacturer'],
    "$row_rs_RobesonWebSpecials[\'manufacturer\']"))) {echo "SELECTED";}
    ?>><?php echo $row_rs_RobesonWebManufacturer['manufacturer']?></option>

    Needless to say, this line is embedded in this Php code to create the
    drop-down menu...

    <select name="manufacturer">
    <?php
    do {
    ?>
    <option value="<?php echo
    $row_rs_RobesonWebManufacturer['manufacturer']?>" <?php if
    (!(strcmp($row_rs_RobesonWebManufacturer['manufacturer'],
    "$row_rs_RobesonWebSpecials[\'manufacturer\']"))) {echo "SELECTED";}
    ?>><?php echo $row_rs_RobesonWebManufacturer['manufacturer']?></option>
    <?php
    } while ($row_rs_RobesonWebManufacturer = mysql_fetch_assoc
    $rs_RobesonWebManufacturer));
    ?>
    </select>

    What's up? These "drop-downs from another table" work fine in "Add" forms.
    They just seem to crap out in "Update" forms. Attached is the entire page
    for consulting.

    Thanx,

    --
    Robb Kerr
    Digital IGUANA
    Helping Digital Artists Achieve their Dreams
    http://www.digitaliguana.com
    http://www.cancerreallys.org
    Robb Guest

  2. #2

    Default Re: DW Php update form where one field is menu from another table

    Try: news://forums.macromedia.com
    macromedia.dreamweaver.
    ----------------------
    zerof
    ----
    "Robb Kerr" <com> escreveu na mensagem
    news:net... 
    ----------------
    Zerof Guest

  3. #3

    Default Re: DW Php update form where one field is menu from another table

    Thanx. I placed there as well, but wasn't getting any responses so thought
    I'd try this group as it has been invaluable in the past.

    Finally got a response on the Macromedia group so I'll try that suggestion.

    --
    Robb Kerr
    Digital IGUANA
    Helping Digital Artists Achieve their Dreams
    http://www.digitaliguana.com
    http://www.cancerreallys.org
    Robb Guest

Similar Threads

  1. Binding form field to table field.
    By Bill in forum Microsoft Access
    Replies: 2
    Last Post: January 9th, 11:41 AM
  2. Update a table without using a form
    By Wrapper Guy in forum Coldfusion Database Access
    Replies: 3
    Last Post: February 8th, 12:01 AM
  3. dynamic form field update
    By evvo in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: June 21st, 03:57 PM
  4. Display Field from unrelated table in form
    By PC in forum Microsoft Access
    Replies: 4
    Last Post: September 20th, 02:12 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139