Topic awaiting preservation: Run loop through query results several times? (Page 1 of 1)

Let's see if I can explain this so that it makes sense.

I have a JavaScript script that goes like this:
var messageurl = new Array()
messageurl[0]="http://www.blah.com/link1"
messageurl[1]="http://www.blah.com/link2"
messageurl[2]="http://www.blah.com/link3"

var messageimg = new Array()
messageimg[0]="blah.jpg"
messageimg[1]="blah2.jpg"
messageimg[2]="blah3.jpg"

and so on, with several other arrays

Now, i want to retrieve the data for those arrays from MySQL. My question is, can I retrieve all of the info at one time ("select * from...."), and then loop once through the results to populate messageurl, then loop through the results again to populate messageimg, etc? Each row in the DB would include one of each (messageimg, messageurl, etc)

Of should I do a select statement for each array, and loop that way? Obviously, multiple select statements isn't what I want to do. But if it's the only way.....

Tips? Suggestions? Death Threats?

why cant you set both variables in one loop?

begin loop
messageurl[i]=row[data1]
messageimg[i]=row[data2]
end loop

Pugzly: If I understand the question (I'm not on form today) then perhaps this might be what you are looking for:
www.gurusnetwork.com/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=20&t=000020

You could use one select to grab all the data and load them into arrays and then spit the contents out as you require them. I think that might help cut down the hits the DB gets.

Emps


You're my wife now Dave

Pugzly, you can do both things in one loop like Grumble said... But, if you don't want to mix those JS arrays (in order to improve readability), you can do something like this:

$array_str1 = ""; $array_str2 = "";

while ($row = mysql_fetch_array()) {
    $array_str1 .= "blahblah1[index] = $row[field1]\n"; // first JS array
    $array_str2 .= "blahblah2[index] = $row[field2]\n"; // second JS array
}

print $array_str1; // print first JS array
print $array_str2; // print second JS array




[This message has been edited by mr.maX (edited 12-11-2001).]

Um but yeah you can loop through twice



:[ Computers let you make more mistakes faster than any other invention in human history, with the possible exceptions of handguns and tequila. ]: