I have three MySql tables (about 2 gig each) and I need to be able merge the results of my SQL searche into one array, sort them and then display them with NEXT links. I was doing this before with a table at a time and the SQL order statement was doing the work for me. Now ith the three tables at a time it puts way to much load on my server. I know php4 has this feature but my server runs just fine now and I really do not want to make any changes. Any suggestions?
Maybe this simple code is enough:
function array_merge($a1,$a2) { while(list($key,$val)=each($a1)) $out[$key]=$val; while(list($key,$val)=each($a2)) $out[$key]=$val; return($out); }