I created simple database which store data using a simple from But I added textarea. I cannot see the textarea data in database and all other fields are ok Form Page <form id="form1" name="form1" method="post" action="add2.php"> <table width="864" border="1" cellspacing="0" cellpadding="00"> <tr> <td width="97" height="44">Title</td> <td width="761"><input name="title" type="text" id="title" size="100" /></td> </tr> <tr> <td height="39">Summary</td> <td><input name="sum" type="text" id="sum" size="100" /></td> </tr> <tr> <td height="184">Text</td> <td><textarea rows="8" name="text1" cols="68"></textarea></td> </tr> <tr> <td height="41">Author</td> <td><input name="by" type="text" id="by" size="100" /></td> </tr> <tr> <td height="24"> </td> <td><label> <input type="submit" name="Submit" value="Submit" /> </label></td> </tr> </table> </form> HTML: Database page <? $username="*******"; $password="*********"; $database="*********"; $title=$_POST['title']; $sum=$_POST['sum']; $text=$_POST['text1']; $by=$_POST['by']; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query = "INSERT INTO data VALUES ('','$title','$sum','$text','$by')"; mysql_query($query); mysql_close(); ?> PHP:
Your code is fine. I think there may be some variable are overwritten. Please post the whole page code. Both are the different pages or same?
Change: <td><textarea rows="8" name="text1" cols="68"></textarea></td> PHP: to: <td><textarea rows="8" id="text1" cols="68"></textarea></td> PHP: