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 the same time rest of the data with 
number is displayed.
Php script
// open the connection
$conn = mysql_connect("localhost", "cde_mail", "h63");

// pick the database to use 

// 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    
     id             int(11)            No                auto_increment         
     checkbox  char(2)         BINARY   No  []                              
     email    varchar(150)    No     

Reply via email to