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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php