Click here to Skip to main content
15,914,642 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
AnswerRe: Help regarding php Pin
jceresini6-Mar-09 12:49
jceresini6-Mar-09 12:49 
Questionphp basics Pin
s4_sabahatf1-Feb-09 17:19
s4_sabahatf1-Feb-09 17:19 
AnswerRe: php basics Pin
EliottA2-Feb-09 2:30
EliottA2-Feb-09 2:30 
AnswerRe: php basics Pin
Rao Rafique9-Feb-09 0:36
Rao Rafique9-Feb-09 0:36 
AnswerRe: php basics Pin
Ioannis_o59-Feb-09 6:01
Ioannis_o59-Feb-09 6:01 
QuestionPHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
LazyDragonfist31-Jan-09 19:01
LazyDragonfist31-Jan-09 19:01 
AnswerRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
EliottA2-Feb-09 2:33
EliottA2-Feb-09 2:33 
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
LazyDragonfist2-Feb-09 4:31
LazyDragonfist2-Feb-09 4:31 
Thanks for your reply.
I used LIMIT its working for first 30 records fast but after that
its very slow around 100 sec.
that is : "select * from table1 limit 0,10"
that is : "select * from table1 limit 10,10"
that is : "select * from table1 limit 20,10"
.
.
.
.
.
but "select * from table limit 100,10" is not working
taking long time and php time outs.

I used AJAX too but browser hangs (because of long time execution).
I tried :

"select * INTO OUTFILE from table1 limit 200,100
INTO OUTFILE '/tmp/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
this says permission denied (password:yes)"

What i do.


Pavan.
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages [modified] Pin
EliottA2-Feb-09 4:34
EliottA2-Feb-09 4:34 
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
LazyDragonfist2-Feb-09 4:44
LazyDragonfist2-Feb-09 4:44 
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
EliottA2-Feb-09 4:46
EliottA2-Feb-09 4:46 
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
LazyDragonfist2-Feb-09 4:53
LazyDragonfist2-Feb-09 4:53 
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages [modified] Pin
EliottA2-Feb-09 5:02
EliottA2-Feb-09 5:02 
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
LazyDragonfist2-Feb-09 5:13
LazyDragonfist2-Feb-09 5:13 
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
EliottA2-Feb-09 5:14
EliottA2-Feb-09 5:14 
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
EliottA2-Feb-09 5:15
EliottA2-Feb-09 5:15 
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
LazyDragonfist2-Feb-09 5:32
LazyDragonfist2-Feb-09 5:32 
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
EliottA2-Feb-09 5:54
EliottA2-Feb-09 5:54 
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
LazyDragonfist2-Feb-09 6:07
LazyDragonfist2-Feb-09 6:07 
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
EliottA2-Feb-09 6:09
EliottA2-Feb-09 6:09 
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
LazyDragonfist2-Feb-09 6:20
LazyDragonfist2-Feb-09 6:20 
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
EliottA2-Feb-09 6:23
EliottA2-Feb-09 6:23 
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
LazyDragonfist2-Feb-09 6:37
LazyDragonfist2-Feb-09 6:37 
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
EliottA2-Feb-09 6:39
EliottA2-Feb-09 6:39 
GeneralRe: PHP and MYSQL Getting all rows (around 10000 rows)of a query in a single html pages Pin
LazyDragonfist2-Feb-09 6:45
LazyDragonfist2-Feb-09 6:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.