Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <table width="90%" align="center" cellpadding="4" cellspacing="1" bordercolor="#FFFFFF">
- <tr bgcolor="#004AC6" class="bod">
- <td width="10%">
- <div align="center"><strong><font color="#FFFFFF" size="2">Job #</font></strong></div></td>
- <td width="40%">
- <div align="center"><strong><font color="#FFFFFF" size="2">Job Summary</font></strong></div></td>
- <td width="35%">
- <div align="center"><strong><font color="#FFFFFF" size="2">Key Skills</font></strong></div></td>
- <td width="5%">
- <div align="center"><strong><font color="#FFFFFF" size="2">Location</font></strong></div></td>
- <td width="10%">
- <div align="center"><strong><font color="#FFFFFF" size="2">Status</font></strong></div></td>
- </tr>
- <?php
- $host = "localhost";
- $username = "hightech_sudhir"; //* use the database name given by Linksky
- $password = "vsudhir"; //* use the database password given by Linksky
- $dbname = "hightech_hightechprosjobs"; //* the name given by Linksky
- @ $db = mysql_connect($host, $username, $password);
- if (!$db)
- {
- echo "Error: Could not connect to database. Please try again later.";
- exit;
- }
- mysql_select_db($dbname);
- /* Performing SQL query */
- $query = "SELECT * FROM jobs where Activated = 'Yes' order by JobID desc;";
- $result = mysql_query($query) or die("Query failed : " . mysql_error());
- /* Printing results in HTML */
- $num_results = mysql_num_rows($result);
- for ($i=0; $i <$num_results; $i++)
- {
- $row = mysql_fetch_array($result);
- $jobid = stripslashes($row["JobID"]);
- echo "<tr bgcolor='#EEEFF4'>";
- echo "<td align='center' width='10%'><font size='2' face='verdana'>".$jobid. "</font></td>";
- echo "<td valign='top' width='40%'><font size='2' face='verdana' class='sud'><a href='viewJob.php?jobid=".$jobid ."'><strong>".htmlspecialchars(stripslashes($row["JobTitle"]))."</strong></a></font><br>";
- echo "<font size='1' style='verdana'>".substr(htmlspecialchars(stripslashes($row["Description"])),0,105)."...</font></td>";
- echo "<td valign='top' width='32%'><font size='1' face='verdana'>" .htmlspecialchars(stripslashes($row["KeySkills"])). "</td>";
- echo "<td valign='top' width='8%'><font size='1' face='verdana'>".htmlspecialchars(stripslashes($row["Location"]))."</td>";
- echo "<td valign='top' width='10%'><font size='1' face='verdana'>".htmlspecialchars(stripslashes($row["Status"]))."</td></tr>";
- }
- print "</table>\n";
- mysql_close($db);
- ?>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement