<?php require ('get_connected.php'); $sql = "SELECT * FROM canada"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { } } ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td>NAME:</td> <td>YEAR:</td> <td>MAKE:</td> <td>MODEL:</td> <td>VIN:</td> <td>LETTER SENT:</td> </tr> <?php while($row = mysql_fetch_array($result)) { echo "<tr> <td>" . $row['first_name'] . " " . $row['$last_name'] . "</td> <td>" . $row['vehicle_year'] . "</td> <td>" . $row['vehicle_make'] . "</td> <td>" . $row['vehicle_model'] . "</td> <td>" . $row['vin'] . "</td> <td><input name='letter_sent' type='checkbox' value='" . $row['letter_sent'] . "' /></td> </tr>"; } ?> </table>
desculpem, postei o codigo errado.
o que pretendo é apenas as checkbox, não os outros campos
queria assim:
checkbox 1 checkbox 2 checkbox 3
checkbox 4 checbox 5 checbox 6
é possivel?
<?php mysql_connect("localhost","root","pass"); mysql_select_db("pass"); $query_siseg=mysql_query("SELECT * FROM escolhas ORDER BY id"); ?> <table style="font: 10px verdana;" border="0" cellpadding="0" cellspacing="0" width="600"> <tbody><tr> <?php while($row=mysql_fetch_array($query_siseg)){ ?><td width="250"><?php while($row=mysql_fetch_array($query_siseg)){ ?> <input type="checkbox" name="id[]" value="<?php echo $row['id']; ?>"/> <?php echo $row['doenca'];?> <?php }; } ?>