RE: [PHP] MySQL>Limit size
> > Are you using POST or GET for your form? Show some code... > > I use get. But I tried to post and look ok. Why this difference ? > > Christian, > You can only send so much data through GET, because the URL is limited as to how long it can be. It may be different for each browser, but I think it's usually 1024 characters. There is no limit with POST. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] MySQL>Limit size
> Are you using POST or GET for your form? Show some code... I use get. But I tried to post and look ok. Why this difference ? Christian, -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] MySQL>Limit size
> I have a form with a textarea. When I put a long text(one word page for > example), when I submit, the form is not submitted. I have to remove > some line to submit. I don't have any limit in the textarea. The content > of this form is sorted in a MySQL database. I tried to set the field > where the textarea will be stored to LONGTEXt or LONGBLOB but I have all > the time the same problem. Are you using POST or GET for your form? Show some code... ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] MySQL>Limit size
Hello, I have a form with a textarea. When I put a long text(one word page for example), when I submit, the form is not submitted. I have to remove some line to submit. I don't have any limit in the textarea. The content of this form is sorted in a MySQL database. I tried to set the field where the textarea will be stored to LONGTEXt or LONGBLOB but I have all the time the same problem. Is it a MySQL limit problem ? or form (textarea) problem ? Christian, -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] mysql LIMIT
> can I use limit to show the 2nd record on without knowing > how many more records there might be? > > also, what happens if I set the limit in a mysql statement > (LIMIT 5,10), but there are only 3 results? 7 results? My answer would tend to be that you should try it for yourself and see... But anyway, without having tried it myself recently, the first question is that you could use LIMIT (2, 1) and you'd probably get what you're trying for. As for the second question, you'll only get what records there are. If your limit excludes all possible results then you'll get no result (ie. If you use LIMIT(5, 10) and you've only got 3 records, then you won't get anything back at all. If you've got 7 records then you'll get the last 3 of them). But in all honesty, you could have worked this out for yourself fairly quickly with some simple testing of your own. CYA, Dave -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql LIMIT
Alexander Ross wrote: > > can I use limit to show the 2nd record on without knowing how many more > records there might be? > > also, what happens if I set the limit in a mysql statement (LIMIT 5,10), but > there are only 3 results? 7 results? This looks like a question that could be answered with a 10 second test query! Cheers, Rob. -- .-. | Robert Cummings | :-`. | Webdeployer - Chief PHP and Java Programmer | :--: | Mail : mailto:[EMAIL PROTECTED] | | Phone : (613) 731-4046 x.109 | :--: | Website : http://www.webmotion.com | | Fax : (613) 260-9545 | `--' -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] mysql LIMIT
can I use limit to show the 2nd record on without knowing how many more records there might be? also, what happens if I set the limit in a mysql statement (LIMIT 5,10), but there are only 3 results? 7 results? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php