Re: Textfields dont fully populate
| From: | Bas | Date: | Sat, 22 Nov 2003 17:40:48 +0000 |
| Subject: | Re: Textfields dont fully populate | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-170674@lists.php.net to get a copy of this message | ||
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)