Hi,
I working on a html table and want to get row wise information of that. please check the attachment.
this is my code
<?php
//if(isset($_POST['submit']))
// {
include ("db.php");
$query_for_result=mysql_query("SELECT * FROM pro_production ORDER BY production_id");
$num=mysql_numrows($query_for_result);
//echo <<<end
//<table align="right" >
//<tr>
//<td bgcolor="#6f0d00" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; padding:3px 5px 3px 5px; color:#FFFFFF;" >Total Result Search</td><td> </td><td bgcolor="#000000" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; padding:3px 5px 3px 5px; color:#FFFFFF;">$num</td>
//</tr>
//</table>
//end;
mysql_close();
?>
<div id="main" style="width: 100%; float:left; border:solid #CCCCCC; background-color:#FFFFFF; overflow:scroll; height:500px;">
<table width="1800" align="center" border="1" cellspacing="0" cellpadding="0" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; color:#000000; border:solid #d6d4d5; border-width:1px; margin-top:0px;">
<tr>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >S.No.</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Booking Date</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Delivery Date</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Order Number</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Customer Name</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Status</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Product Range</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Cover</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Size</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Accessory</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Bag</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Packing</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Delivery</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Paper</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Coating</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Priority</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Advance</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >G Total</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Balance</td>
</tr>
<?php
$i=0;
while ($i < $num)
{
$f1=mysql_result($query_for_result,$i,"production_id");
$f2=mysql_result($query_for_result,$i,"booking_date");
$f3=mysql_result($query_for_result,$i,"delivery_date");
$f4=mysql_result($query_for_result,$i,"order_no");
$f5=mysql_result($query_for_result,$i,"salutation");
$f6=mysql_result($query_for_result,$i,"customer_name");
$f7=mysql_result($query_for_result,$i,"status");
$f8=mysql_result($query_for_result,$i,"product_range");
$f9=mysql_result($query_for_result,$i,"cover");
$f10=mysql_result($query_for_result,$i,"size");
$f11=mysql_result($query_for_result,$i,"accessory");
$f12=mysql_result($query_for_result,$i,"bag");
$f13=mysql_result($query_for_result,$i,"packing");
$f14=mysql_result($query_for_result,$i,"delivery");
$f15=mysql_result($query_for_result,$i,"coating");
$f16=mysql_result($query_for_result,$i,"priority");
$f17=mysql_result($query_for_result,$i,"advance");
$f18=mysql_result($query_for_result,$i,"gtotal");
$f19=mysql_result($query_for_result,$i,"balance");
$f20=$f5.$f6;
$f21=mysql_result($query_for_result,$i,"paper");
$id=$i+1;
?>
<!--<tr onclick="myFunction(this)">-->
<tr >
<!--<td valign="top" style="font-size:11px; " align="center" ><?php echo htmlentities($f1); ?></td>-->
<td valign="top" style="font-size:11px; " align="center" ><?php echo $id; ?></td>
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f2; ?></td>
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f3; ?></td>
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f4; ?></td>
<!--<td valign="top" style="font-size:11px; " align="center" ><?php echo $f5; ?></td>-->
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f20; ?></td>
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f7; ?></td>
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f8; ?></td>
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f9; ?></td>
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f10; ?></td>
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f11; ?></td>
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f12; ?></td>
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f13; ?></td>
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f14; ?></td>
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f21; ?></td>
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f15; ?></td>
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f16; ?></td>
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f17; ?></td>
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f18; ?></td>
<td valign="top" style="font-size:11px; " align="center" ><?php echo $f19; ?></td>
</tr>
<?php
$i++;
}
?>
</table>
</div>
What i want that if i select row first and the click on any of the bottom buttons then i could get the whole information of that row.
I have done lot of search but i only able to get the data when click on the row itself but not when i clicked on the bottom button,
So if any one can help me in this regard then i will be very thankful.
thanks