Sorry about this. My mailserver hates me ;)
Hi everybody!
I'm new to this list and joind because I ran in to some trouble last
night... I'm developing a medium sized web site where you should be able to
post questions and get them answered, sort of a faq. Anyway - both the
question field and the anwser field are stored as TEXT in a MySQL db. When
these fields get larger then just your average question it mocks up my
php-scripts real bad. As I've understood there is some values in the php.ini
that might do the trick - but I would prefer not to change these. And
besides, I don't think that the the fields have been that big when I tried
it so that it would run in to these limits.
Anyway to explain my problem a bit more; I did some stupid things when I
first started to script the page. I did three variables $xhtmlstart,
$xhtmlend and $xhtmlmenu. The first and second explains them selfe, right?
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
de db work once and then just display the variable. I haven't been in to php
that long so I'm learning as I go... I've been pasing these three variables
as POST-variables that I rawurldecoded... maybe I should use session
variables or just do the db work over and over again?!
Anyway, when choosing a question that has loads of text put in to it, IE
tries to reload the page several times and eventually stops only displaying
the accual new xhtml-code I've echoed out on that page, skipping the POST,
variables and skipping the questions output. In Mozilla it works as it
should most of the tim and in Opera 6 and 7 it starts out okej but the
script aborts half-way through only displaying $xhtmlstart and 2/3 of the
big question...
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?
If it helps I'm using Win XP, Apache 2.0.40, PHP 4.0.4, MySQL 4.0.3-beta and
I echo out my pages to work with the XHTML standard...
- Bobo Wieland, Sweden.
[EMAIL PROTECTED] www.elstudion.com www.elstudion.com/bobo
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
