mysql check boxes

From: Date: Fri, 24 Jun 2005 09:25:17 +0000
Subject: mysql check boxes
Groups: php.db 
Request: Send a blank email to php-db+get-39757@lists.php.net to get a copy of this message
Dear Friends, I have mysql database and php script. Script pulls all the data with their serial number in html form, from database however, I want each field pulled to be preceeded by a check box. I created field in table and entered array for check boxes in php script, still check boxes aren't displayed.at the same time rest of the data with serial number is displayed. ------------------------------------------------------------------------------ ------ Php script ------------------------------------------------------------------------------ ------ <?php // open the connection $conn = mysql_connect("localhost", "cde_mail", "h63"); // pick the database to use mysql_select_db("wwwabcde_mail",$conn); // create the SQL statement $sql = "SELECT * FROM subscriber"; // execute the SQL statement $result = mysql_query($sql, $conn) or die(mysql_error()); //go through each row in the result set and display data while ($newArray = mysql_fetch_array($result)) { // give a name to the fields $id = $newArray['id']; $checkbox = $newArray['checkbox']; $testField = $newArray['email']; //echo the results onscreen echo " $id $checkbox $testField <br>"; } ?> ----------------------------------- mysql table structure -------------------------------    Field  Type Attributes Null Default Extra Action  id  int(11)   No    auto_increment   checkbox  char(2) BINARY No  []     email  varchar(150)   No   

« previous php.db (#39757) next »