php/mysql - unwanted blank row...

[kabe243]

hello there,
i've been trying to get this to work properly for hours now, but even after reducing the code to the bare minimum, i can't find what's wrong... maybe someone here can help me...
i'm working with php and mysql. i have a page that is supposed to insert a row of text into the database from a form, which it happily does. the problem is that everytime TWO rows are inserted of which the first one is blank. here is the code:

<?
$username="username";
$password="password";
$database="database_name";

$ins_content=$_POST['ins_content'];

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO content (content_text) VALUES ('$ins_content')";
mysql_query($query);

mysql_close();
echo "'$ins_content' written to database";
?>


any ideas? please let me know.

[r937]

sounds like a php problem, not a mysql problem

well, except for the fact that if you really are inserting "blank rows" then you have failed to declare the table properly

[kabe243]

thanks for your reply. sometimes one is just looking in all the wrong places... like you said it was the php not mysql. the blank row got inserted when the page loaded. all it needed was a little if(){} statement... doh!
cheers again - kabe243