Re: [PHP-DB] using POST data for a readfile

2005-04-13 Thread Andrés G . Montañez
> I didn't mean to offend or say your way was wrong. I was just offering > an alternative method. Oh no, you didn't offended me in anyway! I was saying that my example should not be used, because it do not work. -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo - Urug

[PHP-DB] MySQL SQL CACHE

2005-04-13 Thread Joe Harman
Hello, First time on this list, I generally use the general PHP list... but I was curious if alot of people are using SQL CACHE with MySQL and PHP and does it seem to increase the performance... or lighten the load on mysql for you? Thanks Joe

Re: [PHP-DB] using POST data for a readfile

2005-04-13 Thread mel list_php
Thank you very much! Here is the winner (actually a mix of both!) download test.pdf and in the callFile I have a switch on dlId_to_dl. I didn't get the tag though, what does that mean? From: Andrés G. Montañez <[EMAIL PROTECTED]> Reply-To: Andrés G. Montañez <[EMAIL PROTECTED]> To: php-db@list

Re: [PHP-DB] using POST data for a readfile

2005-04-13 Thread Martin Norland
mel list_php wrote: Thank you very much! [snip] I didn't get the tag though, what does that mean? It was merely a cautionary warning about sites that force a base href for relative URIs (including, of course, URLs) See: http://www.w3.org/TR/html4/struct/links.html#h-12.4 cheers, -- - Martin Norl

[PHP-DB] mysql query plan

2005-04-13 Thread Eddie Peloke
Hello, We are working to optimize a few queries. When we run the query with Explain, it appears that the query optimizer is not using one of the tables index and doing a full table scan while it appears to use other tables' indices properly. We then remove the table with the full scan, run again

RE: [PHP-DB] mysql query plan

2005-04-13 Thread Bastien Koert
is there a join in the sql? Joins can be tricky since the order of the joins can determine the number of records selected from each table. If the joins result in a larger table joining with a smaller table, it could result in more than 30% of the rows being selected and the optimizer will ignore