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]