[PHP-WIN] Re: Subject: TEXT

[Neil Smith]

Message-ID: <000401c2b896$5b7ed880$24fb1e0a@elstudion>
From: "Bobo Wieland" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Date: Fri, 10 Jan 2003 11:39:53 +0100
MIME-Version: 1.0
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Subject: TEXT

Hi everybody!

I'm new to this list

Then, please take care not to repeatedly post 1-line emails saying "Hi" :-)

question field and the anwser field are stored as TEXT in a MySQL db.

Use BIGTEXT or specify a column size - do you have access to PHPMyAdmin for this database ? If not, install it, you will learn a great deal about what can be done with column types.

php-scripts real bad. As I've understood there is some values in the php.ini

No, its a MySQL setting specified in your database format ("schema") which determines this. Execute the MySQL command "SHOW STRUCTURE" on your databsae to get a listing of the column types which are currently in use.

besides, I don't think that the the fields have been that big when I tried

Always think ahead :-) (Alternative : Use the force, Luke :-)

$xhtmlend and $xhtmlmenu. The first and second explains them selfe, right?

Nope, not a clue. Sorry.

But the last is a menu where you can choose questions. It shows the last ten
questions in all categories, and there can be n categories... The reason I
made these three variables is that I thought that it might be faster to do

<<Snip>> : You're rambling, Please get to the point. Have you checked your HTML to determine where in your script the function chokes ? Turn on error_reporting(E_ALL) and see whether you get any errors reported - on screen or in your servers error log if its configured that way.

Could you give me some hint on this one? What to do with the variables, and
how to work around the problem with large amount of data? There isn't some
MySQL type that goes in between VARCHAR/TINYTEXT and TEXT, right?

Very much so : at this point it is traditional to point you to the appropriate documentation on column types

:http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Column_types

Cheers,
Neil Smith.

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php