hi
i am creating web newsprogram by php and mysql.
how to i can use text data type for saving contents of articles in database?
when i use text format,contents save in the tables unless eny new line.
howto i can insert \n element in text format?
-
When you´ll catch data for a text field, you ought to use a
textarea/textarea.
When you´ll pull it from the database to the screen, you have to use
nl2br($field) to conver \n to br.
ali asghar torabi parizy [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
hi
i am creating web
The problem could be in the HTML page.
I suppose You use a form to submit data.
If You want to pass more than about 1K data You must use POSTs and not GETs.
The Get option has a limit in the URL len so You can not successful
pass more than 1K bytes (browser/platform specific limit). The url in
PROTECTED]
To: Lekeas GK [EMAIL PROTECTED]
Cc: gerald_clark [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, July 18, 2003 3:05 PM
Subject: Re: Working with the text datatype in Mysql
| On Friday, July 18, 2003, at 09:25 AM, Lekeas GK wrote:
| The version of MySQL is 3.23, the platform
Hi All,
I am managing a small database where a few fields are defined as being of
type text. In my understanding, this would allow the user to enter up to
about 65,000 characters in the text field.
However, if the user types about 2,000 characters, then nothing is entered
in the database. I have
:11 PM
Subject: Re: Working with the text datatype in Mysql
| You supply almost no useful information here.
| What version of MySQL are you using?
| What platform?
| What language?
| How do you check to see if anything was entered?
|
|
| Lekeas GK wrote:
|
| Hi All,
|
| I am managing a small
with the text datatype in Mysql
| You supply almost no useful information here.
| What version of MySQL are you using?
| What platform?
| What language?
| How do you check to see if anything was entered?
|
|
| Lekeas GK wrote:
|
| Hi All,
|
| I am managing a small database where a few fields
On Friday, July 18, 2003, at 09:25 AM, Lekeas GK wrote:
The version of MySQL is 3.23, the platform is Solaris, the language is
English and the way I check whether data has been entered in the
database or
not is by running a select query on the database.
Was that of any help? I tried searching
]
Sent: Friday, July 18, 2003 3:05 PM
Subject: Re: Working with the text datatype in Mysql
| On Friday, July 18, 2003, at 09:25 AM, Lekeas GK wrote:
|
| The version of MySQL is 3.23, the platform is Solaris, the language is
| English and the way I check whether data has been entered
there is a world market for maybe five computers.
Thomas Watson, Chairman of IBM, 1943.
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Lekeas GK [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, July 18, 2003 3:00 PM
Subject: Re: Working with the text datatype in Mysql
]
To: Lekeas GK [EMAIL PROTECTED]
Sent: Friday, July 18, 2003 4:31 PM
Subject: RE: Working with the text datatype in Mysql
| George,
| You keep leaving out the vital bits. What are your sers using to enter
| this data? We know it's a web page, but what script does that web page
run
| when the user
A. Brahier [EMAIL PROTECTED]
To: Lekeas GK [EMAIL PROTECTED]
Sent: Friday, July 18, 2003 5:01 PM
Subject: RE: Working with the text datatype in Mysql
| hmm, add this after your mysql_query() line in the script
|
| echo mysql_error();
|
| Does that return anything?
|
|
| -Original Message-
| From
A. Brahier
| Cc: [EMAIL PROTECTED]
| Subject: Re: Working with the text datatype in Mysql
|
|
| Nope, same situation...When you hit the submit button, nothing happens...I
| check the database afterwards and find out that nothing was inserted...
|
| George
|
| I think there is a world market for maybe five
Hi All,
I am managing a small database and some of the tables
need to be strings of an average length of about 2,000
characters.
I decided to use the text datatype to store this
information knowing that the upper limit is about
65,000 characters.
However, the system crashes when the user tries
Lekeas GK wrote:
Hi All,
I am managing a small database and some of the tables
need to be strings of an average length of about 2,000
characters.
I decided to use the text datatype to store this
information knowing that the upper limit is about
65,000 characters.
However, the system crashes
15 matches
Mail list logo