Select HTML Row and get cells Values.

[rajeshkr]

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

[Ch0cu3r]

What bottom button?

 

I do not understand your question.

[rajeshkr]

hi

Please find the attachment for what i want to achieve.

thanks