Search found 8 matches

by jsky
Mon Feb 18, 2008 3:40 am
Forum: PHP - Code
Topic: SQL and Arrays
Replies: 6
Views: 60

Re: SQL and Arrays

I used your code, but I forgot to add that i'm using paging:
select * from table where id in $array1 $LIMIT;
$LIMIT = $LIMIT($a,$b);

I made a loop but it only works without paging.

Code: Select all

$data_array[$i]['numhits'] = $hits[$i];
by jsky
Mon Feb 18, 2008 1:37 am
Forum: PHP - Code
Topic: SQL and Arrays
Replies: 6
Views: 60

Re: SQL and Arrays

Thanks a lot! :oops:
by jsky
Mon Feb 18, 2008 1:27 am
Forum: PHP - Code
Topic: SQL and Arrays
Replies: 6
Views: 60

Re: SQL and Arrays

Thanks. Yes but even if even if i sort array1, how about array2? They are separate btw.

array1(id)
4
2
1
3
7

array2(hits)
23
14
16
24
45

id 4 has 23 hits.
by jsky
Mon Feb 18, 2008 1:05 am
Forum: PHP - Code
Topic: SQL and Arrays
Replies: 6
Views: 60

SQL and Arrays

I have an array of id's(array1) each with corresponding hits(array2). I'm using an imploded array1 to select ids from a table. like so: select * from table where id in $array1; Now i want to add the corresponding hits(array2) of each id in the query result. The problem is that the result is automati...
by jsky
Thu Feb 14, 2008 12:23 am
Forum: PHP - Theory and Design
Topic: Returning hug results
Replies: 10
Views: 1029

Re: Returning hug results

So ajax responses have max allowable string lengths? Tt would be then harder for me to consider ajax..
by jsky
Wed Feb 13, 2008 11:48 pm
Forum: PHP - Theory and Design
Topic: Returning hug results
Replies: 10
Views: 1029

Re: Returning hug results

More than 1gb if the database is populated completely, but right now i have more than 50MB and the total time it takes the page to load is 8 seconds (local ftp server). And i could just imagine how long it will take when the database is complete and in a live site.
by jsky
Wed Feb 13, 2008 8:24 pm
Forum: PHP - Theory and Design
Topic: Returning hug results
Replies: 10
Views: 1029

Re: Returning hug results

Thanks for your reply, my code has paging in it, the process is just taking too long i think because of the huge contents. Think of them like short stories, and the div that has the longest loading time is the one that displays the highlighted search results hits per line of the story. Would ajax as...
by jsky
Wed Feb 13, 2008 12:54 am
Forum: PHP - Theory and Design
Topic: Returning hug results
Replies: 10
Views: 1029

Returning hug results

I'm currently developing a web application that handles huge contents. In my main page i have 3 panes, each with different functions to show dynamic results (from a search template). I have a problem in loading the entire page because it first waits for all of the 3 divisions to be processed before ...