[SOLVED] Checkbox with displayed with every record in loop??

[mikebyrne]

Hi I can get my records to display but Id like a checkbox to appear with every record. Can I incorporate this into my loop or will i have to display the results in a set table format and place the checkbox within this??

 

My code is:

 

<?php
// let's get some data
include('adminconnect.php');
$sql = mysql_query("SELECT OrderNo, Orderdate, Custname, Amount, Shippingmet FROM admin WHERE Orderdate = DATE_FORMAT(now(),'%y/%m/%d')");
while( $row = mysql_fetch_array($sql) ) {
// loop through and display
?>

<tr align="left">
<td width="33"> </td>
<td width="82"><a href="javascript:openWindow('popup_detail.html', 'NewWindow', 615, 600)" class="black"><?php echo $row['OrderNo'];?></a></td>
<td width="61"><?php echo $row['Orderdate'];?></td>
<td width="61"><?php echo $row['Dispatchdate'];?></td>
<td width="230"><?php echo $row['Custname'];?></td>
<td width="170"><?php echo $row['Trackno'];?></td>
<td width="56" align="right"><?php echo $row['Amount'];?></td>
<td width="21"> </td>
<td width="136">test</td>
</tr>


<?
}
?>
</table>

 

 

[adam291086]

<?php
// let's get some data
include('adminconnect.php');
$sql = mysql_query("SELECT OrderNo, Orderdate, Custname, Amount, Shippingmet FROM admin WHERE Orderdate = DATE_FORMAT(now(),'%y/%m/%d')");
while( $row = mysql_fetch_array($sql) ) {
// loop through and display
?>

<tr align="left">
<td width="33"> </td>
<td width="82"><a href="javascript:openWindow('popup_detail.html', 'NewWindow', 615, 600)" class="black"><?php echo $row['OrderNo'];?></a></td>
<td width="61"><?php echo $row['Orderdate'];?></td>
<td width="61"><?php echo $row['Dispatchdate'];?></td>
<td width="230"><?php echo $row['Custname'];?></td>
<td width="170"><?php echo $row['Trackno'];?></td>
<input type = "checkbox name="checkbox">
<td width="56" align="right"><?php echo $row['Amount'];?></td>
<td width="21"> </td>
<td width="136">test</td>
</tr>


<?
}
?>
</table>

[mikebyrne]

Maybe ive requested the wrong thing? Isn't a checkbox a little box that displays a tick when you select it.

 

The code above seems to provide me with an input box

[mikebyrne]

Fixed it with

<input type = "checkbox" name="checkbox">

 

But the checkbox displays above the valuse as opposed to on the same line

[beansandsausages]

what line of code you want the check box to be next?

 

<td width="61"><?php echo $row['Orderdate'];?></td> here?

<td width="61"><?php echo $row['Dispatchdate'];?></td> here?

<td width="230"><?php echo $row['Custname'];?></td> here?

<td width="170"><?php echo $row['Trackno'];?></td> here?

<input type = "checkbox name="checkbox">

[mikebyrne]

It was just a spacing issue with the html

 

Thanks for all the help