textareas - why are spaces inserted before my recalled data?

[rupertbj]

please look at http://www.rupstar.co.uk/admin.php

you will see that evertime i recall data, I more spaces are inserted into the textarea before my data.

Anyone got a solution?

this is the code to write to the database:

<?php
	$db = "admin";
	$link = mysql_connect( "localhost:/users/rupertbj/domains/rupstar.co.uk/sql/mysql.sock", "root" );
	mysql_select_db( $db, $link ) or die( "Couldn't open $db: ".mysql_error() );
	$sql = "REPLACE INTO adminTable VALUES ( '1', '$introduction', '$whatsnew1', '$whatsnew2', '$whatsnew3', '$whatsnew4' )";
	mysql_query( $sql, $link );
	mysql_close( $link );
?>

and this is the code to display in the textarea:

<textarea name="introduction" cols=40 rows=5 wrap="VIRTUAL">
						<?php echo $introduction ?>
						</textarea>

[erick_w]

Use UPDATE instead, and try to remove wrap="VIRTUAL" from your <textarea> tag.

$sql="UPDATE adminTable SET id='1', introduction='$introduction', whatsnew1='$whatsnew1', whatsnew2='$whatsnew2', whatsnew3='$whatsnew3', whatsnew4='$whatsnew4' )";

Hope it helps! 🙂

[Weedpacket]

And lose the spaces you've got between the <textarea> tags:
<textarea ...><?php echo ... ?></textarea>

[rupertbj]

Thanks weedpacket!
the spaces were the obvious answer - i was trying to make the code look too pretty!!!!!!

also what is the difference with UPDATE and REPLACE?