Passing a variable from a DB

[Anon]

Hi there,

I've got a DB with a bunch of job listings in them. The listings are identifiable by an ID number. What I want to do is for someone to be able to click on the job listing and go to a form which they fill out. The form must already include the ID number and job title. The rest of the details must be filled in by the applicant. This form them gets emailed to the employment agency that advertised the job. The e-mail address is also in the DB, so it must call the email address from the DB.

The way I see it is basically that you would have 2 SELECT statements which retrieves the relevant info from the db and put them in variables. These variables get included in the mail() fuction.

Please tell me if I am on the right track? Or if there is an easier/better way of doing this.

All the best

Stiaan

[Anon]

Whay do 2 SELECT's ?

how about.....

<?php

if($submit)
{
mail("$client","$job_title position","$message","from: $email");
print ("Thank you for applying for the job");
}

else
{
mysql_query(SELECT * FROM $dbtable WHERE ID = '$ID');

while($row = mysql_fetch_row($query))
{
//get columns
$ID = $row[0];
$email = $row[1];
$job_title = $row[2];

print ("<form method='$PHP_SELF' action='post'>");
print ("<input type='text' name='email' value='$email'>");
print ("<input type='hidden' name='ID' value='$ID'>");
print ("<input type='text' name='job_title' value='$job_title'>");
//blah blah blah
print ("<input type='submit' name='submit' value='Submit'>");
print ("</form>");
}
}
?>

Or something to that effect...?

HTH
Scott d~