For Programmers: Free Programming Magazines  


Home > Archive > PHP SQL > August 2004 > Storing Long Descriptions in mySQL (255+ Char.)









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Storing Long Descriptions in mySQL (255+ Char.)
HostSpecs

2004-08-18, 3:57 pm

I'm looking for a way to store job descriptions in a mySQL
database dealing with PHP. I find people jobs on my website locally.
Most of the job descriptions are more than 255 characters in length
so how would I make this work? Could I have a field in the mySQL
database that stores the path to a text file with the description and
then include it somehow into an HTML page? I don't know how I
would do this though, so some simple PHP coding would be greatly
appreciated! Thanks in advance..



----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums


Barand

2004-08-18, 3:57 pm

> Could I have a field in the mySQL database that stores the path to
a text file with the description and then include it somehow into an
HTML page?
>
>

You could do it that way, or, if you need to search on the contents of
the job description field, use a field of type TEXT.

Barand

http://members.aol.com/barryaandrew...agridguide.html easy
data tables - and more

----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums


steve

2004-08-18, 8:56 pm

"HostSpecs" wrote:
> I’m looking for a way to store job descriptions in a mySQL
> database dealing with PHP. I find people jobs on my website

locally.
> Most of the job descriptions are more than 255 characters in length
> so how would I make this work? Could I have a field in the mySQL
> database that stores the path to a text file with the description

and
> then include it somehow into an HTML page? I don’t know how I
> would do this though, so some simple PHP coding would be greatly
> appreciated! Thanks in advance..
>
>
>
> ----------------------------------------
> The post originated from PHP Freaks:
> ----------------------------------------
> http://www.phpfreaks.com
> http://www.phpfreaks.com/forums


You can have fields more than 255 chars. Just define them as "text"
type.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/PHP-SQL-Sto...pict140910.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=471760
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com