Form fields help

[-__webdreamer__]

How do i populate a multiline textfield. All fields populate except the the review

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 value=%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=urldecode($myrow["artist"]), 
	$title=urldecode($myrow["title"]), 
	$picture=urldecode($myrow["picture"]), 
	$review=urldecode($myrow["review"]), 
	$lable=urldecode($myrow["label"]), 
	$format=urldecode($myrow["format"]), 
	$price=urldecode($myrow["price"]),
	$rating=urldecode($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";
} 

cheers
Paul

link
http://thor.ancilenetworks.co.uk/~pferrie/vinrev/adm/myadmin.html
"edit record"

[laserlight]

The textarea element does not have the value attribute, but is of the form:

<textarea attributes>TEXT</textarea>

It is advisable to apply [man]htmlspecialchars/man on your output.
You may also have to use [man]stripslashes/man before you use htmlspecialchars.

[-__webdreamer__]

<textarea attributes>TEXT</textarea>
This wont work because i need to poplute the textarea with a variable $review.

I tried
<textarea attributes>$review</textarea>
But this didnt work

~cheers
Paul

[laserlight]

Sometimes you cant take things literally 🙂

"attributes" refers to the attributes like name, rows, cols.

if ($myrow = mysql_fetch_array($result)) {
	echo "<form method='post' action='edit3.php?tablename=$tablename'>\n";
	while ($myrow = mysql_fetch_array($result)) {
		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 = urldecode($myrow["artist"]),
		$title = urldecode($myrow["title"]),
		$picture = urldecode($myrow["picture"]),
		$review = urldecode($myrow["review"]),
		$lable = urldecode($myrow["label"]),
		$format = urldecode($myrow["format"]),
		$price = urldecode($myrow["price"]),
		$rating = urldecode($myrow["rating"])
		);
	}
	echo "<br><input type='submit' value='Submit' name='submit'>";
	echo "<input type='reset' value='Reset' name='reset'></form>\n";
}

btw, you store your data urlencoded?
I have left out the htmlspecialchars() part.