Including Details in MySQL longer than 255 characters
| From: | Adam Venturella | Date: | Thu, 20 Mar 2003 18:11:54 +0000 |
| Subject: | Including Details in MySQL longer than 255 characters | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-26522@lists.php.net to get a copy of this message | ||
Ok So I have my Database/Tables all set up. What I wanna know how to do /
find a tutorial on is how I might go about including details longer than
255 characters that are referenced by a mysql query. So basically I have
some thing like this on the inputs:
First:
Last:
Email:
Comments:
Now the comments Section, I basically want to type in whatever I want.
Since that could be larger than 255 characters how do I get mysql to
reference that chunck of text in a query. I imagine the text will have to
be stored outside the DB and read in to the HTML at an appropriate time or
done like a message board or something. I would also like to keep it
searchable. So that I could do a search through the whole DB and keep
comments included in that search.... well maybe do a drop down that
references the various fields to search and if you select comments you would
get a select like "select * from data where comments =$input"
Anyway if someone could point me in the right direction I would be very
appreciative.
Adam
aventure@csf.edu