im trying to display data back in to a form. The user first enters the ID in a form and it then takes them to a form which is filled in with there details. So they can update the information.
The first part of the code is just a normal form:
<table width="87%" height="61" cellpadding="0" cellspacing="1">
<tr bordercolor="#FFFFFF">
<td height="23" colspan="2" align="center" valign="top"> <div align="left">
<strong></strong></div></td>
</tr>
<tr>
<td width="50%" height="25" align="center" valign="top"> <div align="left">Enter
job ID</div>
<td width="50%" height="25" align="center" valign="top"> <div align="left">INT
<input name="job_id" type="text" id="job_id">
</div></tr>
<tr>
<td height="3" colspan="2" align="center" valign="top"> </tr>
<tr>
<td height="3" colspan="2" align="center" valign="top"><input type="submit" name="Submit" value="Submit"></tr>
</table>
Ive then created a table on the other page with some php code that doesnt seem to work. :
<?
$db_name = "web";
$table_name = "internal_vacancys";
$connection = @mysql_connect("dfa", "w", "df") or die(mysql_error());
$db = @mysql_select_db($db_name, $connection) or die(mysql_error());
$job_id = $GET['job_id'];
$sql = "SELECT job_id from $table_name where job_id='$POST[job_id]'";
$result = @($sql,$connection) or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
$job_id = $row['job_id'];
$contact_name = stripslashes($row['contact_name']);
$contact_phone = $row['contact_telephone'];
$date_posted = $row['date_posted'];
$job_title = stripslashes($row['job_title']);
$job_summary = stripslashes($row['job_summary']);
$person = stripslashes($row['person']);
$package = stripslashes($row['package']);
$location = stripslashes($row['location']);
$salary = $row['salary'];
}
?>
I then use the following echo statement to display the information:
<?php echo "$contact_name"; ?>
THIS DOESNT WORK, ANY HELP PLEASE
