It works, but just for the first row selected from the table. I think that the problem is that the checkboxes are declared inside a while loop. If i declare manually all checkboxes it works. Any ideas ? Or maybe I'm doing something wrong?
############################################################################ #### echo "<form method=\"post\" action=\"selectare.php?ids[]\">"; echo "<input type=\"Submit\" value=\"Trimite\">"; /* Connecting, selecting database */ $link = mysql_connect("localhost", "root", "adrian") or die("Could not connect"); print "Connected successfully"; mysql_select_db("menagerie") or die("Could not select database"); /* Performing SQL query */ $query = "SELECT * FROM reclamatie"; $result = mysql_query($query) or die("Query failed"); /* Printing results in HTML */ echo "<table border=1>"; echo "<tr><td></td><td>ID</td><td>Subject</td><td>Open</td><td>Close</td></tr>"; while($row = MySQL_fetch_array($result)) { echo "<tr><td><form><input type=\"checkbox\" method=\"post\" name=\"ids[]\" value=\"{$row['id']}\"></form></td>"; echo "<td><a href=\"lowerframe.php?id={$row['id']}\" target=\"lowerframe\">{$row['id']}</a></td>"; echo "<td>{$row['subject']}</td>"; echo "<td>{$row['open']}</td>"; echo "<td>{$row['close']}</td></tr>"; } echo "</table>"; /* Free resultset */ mysql_free_result($result); /* Closing connection */ mysql_close($link); echo "</form>"; ?> ############################### //selectare.php (just displays the id's of selected checkboxes) //$useri=$_POST['useri']; $ids=$_POST['ids']; reset($ids); while (list ($key, $value) = each ($ids)) { echo "$value<br />\n"; } ?> ##################################################### As I said, when I select the first checkbox, I get the id, but when I select any other checkbox, I get the errors PHP Notice: Undefined index: ids in selectare.php PHP Warning: Variable passed to each() is not an array or object in selectare.php ----- Original Message ----- From: "John W. Holmes" <[EMAIL PROTECTED]> To: "'Adrian Partenie'" <[EMAIL PROTECTED]>; "'php'" <[EMAIL PROTECTED]> Sent: Thursday, November 28, 2002 5:54 PM Subject: RE: [PHP] mysql, php, checkbox > > I'm displaying the content of a mysql table with autoincrement index. > I > > want to be able to select the each row from the table using the check > > boxes. In order to do that, i want to assign to each checkbox the > > name=index of selected row. > > I assign to the checkboxes the value of selected id, but I can't > > retreiveit later for further processing. My code looks like this > > > > $query = "SELECT * FROM reclamatie"; > > $result = mysql_query($query) or die("Query failed"); > > > > /* Printing results in HTML */ > > > > echo "<table border=1>"; > > echo > > > "<tr><td></td><td>ID</td><td>Subject</td><td>Open</td><td>Close</td></tr > >" > > ; > > > > while($row = MySQL_fetch_array($result)) { > > echo "<tr><td><form><input type=\"checkbox\" method=\"post\" > > name=\"{$row['id']}\"></form></td>"; // ?????????? > > It looks like your naming it as a number, which won't work for PHP. You > want to name all of your checkboxes the same, with a [] on the name to > make the results an array in PHP. > > ... name="id[]" value="{$row['id']}" > > Then, you'll have $_POST['id'][x] as an array in PHP. Only the > checkboxes that were selected will be in the array, from zero to however > many were checked. The value of $_POST['id'][x] will be whatever was in > the value="..." part of the HTML checkbox... > > ---John Holmes... > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php