Annual report

[insert_php]

<p>mysql_connect(“localhost”,”pscgov_db_psc”, “QRmy#3-n^lvw”);<br />mysql_select_db(“pscgov_db_psc”);</p>
<p>echo “</p>
<p>”;</p>
<p>$serial_no = 1;</p>
<p>$selectData = mysql_query(“select * from ims_annual_report order by serial_no DESC”);<br />while($selectRow = mysql_fetch_assoc($selectData))<br />{<br />if($serial_no%2 == “0”)<br />$bgcolor = “#f9f9f9”;<br />else<br />$bgcolor = “#fff”;<br />echo “</p>
<p>”;<br />echo “</p>
<p> </p>
<p>”;<br />echo “</p>
<p>”;<br />echo “</p>
<p>”;<br />$serial_no++;</p>
<p>}</p>
<p>echo “</p>
<table>
<tbody>
<tr style=”font-weight: bold; background: #eee;”>
<td>Name of Annual Report</td>
<td>View details</td>
</tr>
<tr bgcolor=”$bgcolor”>
<td style=”text-align: left;”>$selectRow[name]</td>
<td><a href=”http://www.psc.gov.bd/db_psc_input/upload_folder/$selectRow[file_upload]”>View details</a></td>
</tr>
</tbody>
</table>
<p>”;<br />[/insert_php]</p>