Jump to content

Archived

This topic is now archived and is closed to further replies.

Imothep

Colum type ? for large chunx of text

Recommended Posts

Hello im using phpmyadmin to configure my tables. And i have a textarea that is supposed to submit information to the mysql table  [code]<textarea name="description" rows="10" cols="30">[/code] and my row name is "description" and i have tried using TEXT TYPE, BLOB TYPE etc it doesnt work :S

Anyone have any idea ?

Share this post


Link to post
Share on other sites
can you post the processing code?? it seems like a coding error. one more thing, have you closed the textarea (</textarea>)?

Share this post


Link to post
Share on other sites
well say if your form tag is like this...
[code]<form method="POST" action"pagename.php?posted=1">[/code]

then you would need to write code to see if that form is submitted...

[code]if($posted == 1)
{
  ...
}[/code]

inside there.. *assuming you have already conected to your database.*

[code]mysql_query("INSERT INTO tablename (description /*any other fields to insert form the form?*/) VALUES ('$_POST[description]' /*same as last comment*/)")or die('error with query #1, debug:'.mysql_error());[/code]

some thing like that any way..

or am i not understanding, and making you sound like you dont know what your doing (sorry if ive assumed that, please give more details if so)

Share this post


Link to post
Share on other sites
umm i think you should chage you're colum type to 'LongText' that shoulkd give you more than enough space.
and for the code summin like this
[code]
<?
$description = $_POST['description'];
if ($description == "")
{
echo"Sorry you didn't fill in the description field.Please go back and fill it in.S";
exit();
}
$query = "INSERT INTO yourtablename (description) VALUES ('$description')"; 
$result = mysql_query($query);
?>

[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.