Re: Unique Field for text field...

You would like to have the id for each row on your page? In a form you add an <input type="hidden" name="rowid[]" value="<?php echo $line["your_item_id"] ; /* insert the id column name */ ?>"> tag to each row (i.e. once in your loop). Note the brackets at rowid[]! That's the way how you get an array named $rowid on the next page via POST or GET (depending on your form method attribute). Even better (if you would like to provide the functionality to change any value): you build your form using arrays for every column and put the rowid as array index for each array variable: printf("<input type=\"text\" name=\"number_ordered[%d]\" value=\"%d\">",

    $line["your_item_id"],
    $line["number_ordered

); If you have a "read-only" table (no form) and you would like to provide a specific row to an edit form, you may place the following link after each row: printf("<a href=\"edit_item.php?editID=%d\">edit row...</a>",

    $line["your_item_id"]

); HTH Steff Jas wrote:

Here is my problem: <?php

    /* Connecting, selecting database */
    $link = mysql_connect("localhost", "", "")
        or die("Could not connect");
    mysql_select_db("shopping") or die("Could not select database");

    /* Performing SQL query */
    $query = "SELECT * FROM cart";
    $result = mysql_query($query) or die("Query failed");

    /* Printing results in HTML */
    print "<table width=\"100%\" border=\"0\" cellspacing=\"0\"

cellpadding=\"3\">\n<tr>

                                  <td colspan=\"6\"><b>Select item(s) for

purchase</b></td>

                                </tr><tr>
                                  <td width=\"3%\"

bgcolor=\"#e4e4e4\"><u>ID</u></td>

                                  <td width=\"10%\"

bgcolor=\"#e4e4e4\"><u>Name</u></td>

                                  <td width=\"15%\"

bgcolor=\"#e4e4e4\"><u>Item Number</u></td>

                                  <td width=\"18%\"

bgcolor=\"#e4e4e4\"><u>Description</u></td>

                                  <td width=\"3%\"

bgcolor=\"#e4e4e4\"><u>Cost</u></td>

          <td width=\"3%\" bgcolor=\"#e4e4e4\"><u>Sale</u></td>
          <td width=\"8%\" bgcolor=\"#e4e4e4\"><u>Add Item</u></td>
                                </tr>";
    while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
        print "\t<tr>\n";
        foreach ($line as $col_value) {
            print "\t\t<td>$col_value</td>\n";
        }
        print "<td width=\"10%\"> <form name=\"add_item\" method=\"post\"

action=\"add_item\"> </form>

                                    <input type=\"text\" name=\"add_num\"

size=\"3\" maxlength=\"6\">

                                    <input type=\"submit\" name=\"add\"

value=\"add\"></form>

                                  </td>\t</tr>\n";
    }
    print "</table>\n";

    /* Free resultset */
    mysql_free_result($result);

    /* Closing connection */
    mysql_close($link);

?> I use this to query the database and put the results into a form for later use... The problem I am having is how would I assign a unique field name for each entry displayed? I am not sure how I can do this with the $col_value simply echoing the results onto the page, if anyone could shed some light on this I would appreciate it. Thanks in advance, Jas