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
$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"];
<Title>Edit Job Posting</title>
<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">
<th>Job Information and Location</th>
<th>Job Description</th>
<td valign=top>
<p><strong>Job Title:</strong><br>
<input type="text" name="JobTitle" value="<?php echo "$JobTitle"?>" size=50
<input type="text" name="Industry" value="<? echo "$Industry"; ?>" size=50
<input type="text" name="Other" value="<? echo "$Other";?>" size=50
<inout type="text" name="Location" value="<? echo "$Location"; ?>" size=50
<input type="text" name="Date" value="<? echo "$Date"; ?>" size=30
<td valign=top>
          <textarea name="Description" cols="50" rows="10"><? echo
"$Description"; ?></textarea>
<td align=center colspan=2><br>
<p><input type="submit" name="submit" value="Update Job"></p>

PHP Database Mailing List (
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