Just change your code to:
$result = mysql_query("SELECT * FROM $tablename WHERE id= $id")or
die("<br>ther was an error<br>
tablename:= $tablename<br>
row id:= $id");
if ($myrow = mysql_fetch_array($result)) {
echo "<form method='post' action='edit3.php?tablename=$tablename'>\n";
do {
printf("<input type='hidden' name='id' value=%s>
Artist <br><input type='text' name='artist' size=25 maxlength=25
value='%s'><br>
Title <br><input type='text' name='title' size=25 maxlength=25
value='%s'><br>
Picture <br><input type='text' name='picture' size=25 maxlength=25
value='%s'><br>
Review <br><textarea name='review' cols=30 rows=5>%s</textarea><br>
Label<br><input type='text' name='label' size=25 maxlength=25
value='%s'><br>
Format <br><input type='text' name='format' size=25 maxlength=25
value='%s'><br>
Price <br><input type='text' name='price' size=10 maxlength=8
value='%s'><br>
Rating <br><input type='text' name='rating' size=10 maxlength=8
value='%s'><br>\n",
$myrow["id"],
$artist=$myrow["artist"],
$title=$myrow["title"],
$picture=$myrow["picture"],
$review=$myrow["review"],
$lable=$myrow["label"],
$format=$myrow["format"],
$price=$myrow["price"],
$rating=$myrow["rating"]);
} while ($myrow = mysql_fetch_array($result));
echo "<br><input type='submit' value='Submit' name='submit'>";
echo "<input type='reset' value='Reset' name='reset'></form>\n";
}
I have not tested this, but it should work(it was a html-problem)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
