RE: [PHP-DB] Including Details in MySQL longer than 255 character s

Possibly use a column type of TEXT for the comments column in your table? > -----Original Message----- > From: Adam Venturella [mailto:aventure@csf.edu] > Sent: Thursday, March 20, 2003 1:12 PM > To: php-db@lists.php.net > Subject: [PHP-DB] Including Details in MySQL longer than 255 > characters > > > 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 > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >