Re: [PHP-DB] Including Details in MySQL longer than 255 characters
Thanks, I totally forgot about that type... And thanks to everyone else who replied! -a "Mike Karthauser" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > on 20/3/03 6:11 pm, Adam Venturella at [EMAIL PROTECTED] wrote: > > > Anyway if someone could point me in the right direction I would be very > > appreciative. > > Change your column type to TEXT rather than varchar(255) > > -- > Mike Karthauser > Managing Director - Brightstorm Ltd > > Email >> [EMAIL PROTECTED] > Web >> http://www.brightstorm.co.uk > Tel >> 0117 9426653 (office) >07939 252144 (mobile) > > Snailmail >> Unit 8, 14 King Square, >Bristol BS2 8JJ > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Including Details in MySQL longer than 255 characters
Possibly use a column type of TEXT for the comments column in your table? > -Original Message- > From: Adam Venturella [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 20, 2003 1:12 PM > To: [EMAIL PROTECTED] > 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 > [EMAIL PROTECTED] > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Including Details in MySQL longer than 255 characters
on 20/3/03 6:11 pm, Adam Venturella at [EMAIL PROTECTED] wrote: > Anyway if someone could point me in the right direction I would be very > appreciative. Change your column type to TEXT rather than varchar(255) -- Mike Karthauser Managing Director - Brightstorm Ltd Email >> [EMAIL PROTECTED] Web >> http://www.brightstorm.co.uk Tel >> 0117 9426653 (office) 07939 252144 (mobile) Snailmail >> Unit 8, 14 King Square, Bristol BS2 8JJ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php