table structure:
id int(11)
bcontent longtext
when i run insert query through php if the data which is going to store in bcontent is small (2-3 lines paragraph) then that query runs successfully but when the size of that data is increases (10-11 lines paragraph) that query gives an error. is there problem with longtext data type? i also tried longblob but no change.
php code:
include("conn.php");
$bcontent = $_POST['bcontent'];
$query = mysql_query("insert into blocks (bcontent) values ('$bcontent')");
if($query)
{
//Success message
}
else
{
//Error message
}
when the size of bcontent is large php throws //Error message.
i also increase the size of post_max_size to 200M in php.ini but no change.
Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
actually it gives me an output which i coded in else condition
is there any error is my query or in table structure? please help me.
