2 databases one script

longbow

posted here before

need some help on a SQL datbase scipt help

i am looking to build a scipt that can read form 2 db's at the same time for example

it will print:

(data from db1)
(data from db2)
(data from db1)
(data from db2)
and so on till there is no data left

but every time i try to do this i end up with it starting with one output of db1 and then printing all of db2 then the rest of db1 i know why it is doing that but i dont want it to
so i need some help so as to how to get it to sopt the loop mid way and continue db1
example:
db1
db2
db2
db2
db1
db1

heres the scipt that im useing

 
<?
$conn = mysql_connect("localhost", "user", "inserthere");
mysql_select_db("test",$conn);
$sql = "SELECT * FROM jorunal ORDER BY id DESC";
$result = mysql_query($sql, $conn) or die(mysql_error());
while($newArray = mysql_fetch_array($result)){ 
$testField = $newArray['journal'];
echo "<p align=\"left\">comment:<br>$testField<br></p>";
}
?>

if it help im useing it as an include on another page
is there some way i can use a counter of some sort or somthing?

longobw

Shrike

You would probably need to read the data into memory before displaying it - it sounds like you currently have 2 nested while loops.

longbow

that i do how would i go about and reading into the memory before hand?
BTW that script is only one of the 2 teh other one is the same just diff Db name

Shrike

Connect to db1
Run a query
Iterate over the result set storing each row in an array

Connect to db2
Run a query
Iterate over the result set storing each row in an array

Iterate over one array
Take data from each array one element at a time to get the alternating effect (it would help if both arrays are the same size)

longbow

i plan on them beaing the same size im setting up a comments and suggestions part of my website and i have it so that they can add there name (or alias) to there comment

thanks ill read up on arrays in my php book if i need any thing else ill be back im sure ill be back for help theres always somethig.. lol
thanks Shirke

Longbow