Weird..

I want to be able to edit records, which I have done in the past, and I
cannot see why it isn't working...  I have tried single qoutes around the
$row =  and that doesn't work either.  here is the code:

$db = @mysql_select_db($db_name, $connection) or die("Could not select
database");
$sql="SELECT * FROM Jobs WHERE id = '$id' ";
$result = mysql_query($sql,$connection) or die("Couldn't execute query");
while ($row = mysql_fetch_array($result))
{
$id = $row["id"];
$Industry = $row["Industry"];
$Other = $row["Other"];
$JobTitle = $row["JobTitle"];
$Description = $row["Description"];
$Location = $row["Location"];
$Date = $row["Date"];
}
?>
<html>
<head>
<Title>Edit Job Posting</title>
</head>
<body>
<h1>Edit Job Posting</h1>
<form method="post" action="do_mod_job.php">
<input type="hidden" name="id" value="<? echo "$id"; ?>">
  <table cellspacing=3 cellpadding=5 align="center">
    <tr>
<th>Job Information and Location</th>
<th>Job Description</th>
</tr>
<tr>
<td valign=top>
<p><strong>Job Title:</strong><br>
<input type="text" name="JobTitle" value="<?php echo "$JobTitle"?>" size=50
maxlength=75></p>
<p><strong>Industry:</strong><br>
<input type="text" name="Industry" value="<? echo "$Industry"; ?>" size=50
maxlength=75></p>
<p><strong>Other:</strong><br>
<input type="text" name="Other" value="<? echo "$Other";?>" size=50
maxlength=75></p>
<p><strong>Location:</strong><br>
<inout type="text" name="Location" value="<? echo "$Location"; ?>" size=50
maxlength=75></p>
<p><strong>Date:</strong><br>
<input type="text" name="Date" value="<? echo "$Date"; ?>" size=30
maxlength=40></p>
</td>
<td valign=top>
<p><strong>Description:</strong><br>
          <textarea name="Description" cols="50" rows="10"><? echo
"$Description"; ?></textarea>
        </p>
</td>
</tr>
<tr>
<td align=center colspan=2><br>
<p><input type="submit" name="submit" value="Update Job"></p>
<br>
</td>
</tr>
</table>
</form>
</body>
</html>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to