Re: Textfields dont fully populate
| From: | PAUL FERRIE | Date: | Sat, 22 Nov 2003 17:47:41 +0000 |
| Subject: | Re: Textfields dont fully populate | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-170675@lists.php.net to get a copy of this message | ||
Thank you Bas, i cant believe that once again it has been down to simple
syntx
cheers
"Bas" <famde.jong@home.nl> wrote in message news:20031122174050.7186.qmail@p
b1.pair.com...
> 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)