<td height="30"><?php echo $row['applicanttitle']; ?> <?php echo $row['applicantfirstname']; ?> <?php echo $row['applicantlastname']; ?> </td> <td height="30"><?php echo $row['applicantemail']; ?> </td> <td><a href="../useruploads/<?php echo togetpath($row["add_date"]) . $row['applicantcvattachment']; ?> " target="_blank">Click Here to View</a></td> <td height="30"><?php echo togetjobname($row['jobid']); ?> </td> <td><?php if ($row['status'] == "1") { echo "Active"; } else { echo "In-Active"; } ?> </td> <td height="30"><?php
$rs = mysql_query_with_throw($sql); $perpage = 20; $currentpage = $_REQUEST['currentpage'] ? $_REQUEST['currentpage'] : '1'; $startrecord = ($currentpage - 1) * $perpage; $totalrows = mysql_num_rows($rs); $result = mysql_query_with_throw($sql . " order by add_date desc LIMIT {$startrecord}, {$perpage}") or die(mysql_error()); $header = '<div class="jobsdata"><div class="row header"><div class="checkboxdiv"><input name="chkSelectAll" type="checkbox" id="chkSelectAll" value="1" onClick="selectAllChk()"></div><div class="column">First Name</div><div class="column">Mobile</div><div class="column" style="width:200px;">Email ID</div><div class="column">Resume</div><div class="column">Posted on</div><div class="column">Operation</div></div>'; $repeat = ''; $j = 1; while ($row = mysql_fetch_assoc($result)) { if ($row['jobstatus'] == '1') { $js = 'Active'; } else { $js = 'Inactive'; } $repeat .= '<div class="row"><div class="checkboxdiv"><input name="chkjobid[' . $j . ']" type="checkbox" value="' . $row['ApplicantID'] . '"></div><div class="column">' . $row['applicantfirstname'] . '</div><div class="column">' . $row['applicantmobile'] . '</div><div class="column" style="width:200px;">' . $row['applicantemail'] . '</div><div class="column"><a href="useruploads/' . togetpath($row["add_date"]) . $row['applicantcvattachment'] . '" target="_blank">View Resume</a></div><div class="column">' . toshowformatdatetime($row["add_date"]) . '</div><div class="column"><a href="index.php?p=applicantdetails&aptid=' . $row['ApplicantID'] . '&jobid=' . $_GET['jobid'] . '">View Details</a></div></div>'; $j++; } echo $header . $repeat . '</div>'; ?> <div class="clear"></div> <div class="row"> <em><strong>With selected</strong> </em>: <a href="javascript:del_rec();">Delete</a></div> <hr/> </form> <div class="row" align="center"><br /> <?php echo generate_pagination("index.php?p=viewapplicants&jobid=" . $_GET["jobid"], $totalrows, $perpage, $currentpage); ?> <br />