If I understand fully on what you are trying to accomplish here is what you can do.
Now I guess my first question would be did you set up this table to have an ID field using auto_increament? If you did your code would be very easy and would do something like the following:
<?
include 'dbconnect.php';
$sql = mysql_query("SELECT * FROM jobs");
while($done = mysql_fetch_array($sql))
{
// Getting the ID and Company for Each
$id = $done['id'];
$company = $done['company'] ;
//Outputting the right link with id.
echo "<a href=\"details.php?id=" . $id . "\">" . $company."</a>";
}
?>
Now you will want to create a second page which I called details.php... You can name this page anything you want just make sure you change it in your code.
<?
include 'dbconnect.php';
//This will get the id number out of the address bar.
$id = $_GET['id'];
//This is select the job with that specific ID.
$q = "SELECT * FROM jobs WHERE id = '$id'";
$r = mysql_query($q);
$row = mysql_fetch_array($r);
//Here is where the outputing of the information goes and is formatted to how you want it to look on the page.
echo $row['company'] . "<BR>" . $row['job'];
?>
Hope that helps.
