[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
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) SnailmailUnit 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
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) SnailmailUnit 8, 14 King Square, Bristol BS2 8JJ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
