Two mysql connections

[Blaze]

Do I need to create two mySQL connections for this?

PHP Code:

$db = mysql_connect($server,$username,$pass);
$query = "SELECT * FROM test";

$results = mysql_query($query);

while ($row = mysql_fetch_array($results) {
      $query = "SELECT * FROM test2";
       $results = mysql_query($query);
} 


or will this bomb out?

[TkTech]

Ehhhh, Dont see what this code is supposed to do, but it wont work with what you have

$db = mysql_connect($server,$username,$pass);
$query = "SELECT * FROM test";

$results = mysql_query($query);

while ($row = mysql_fetch_array($results)  //<-This $result is getting overwritten by the following
{
      $query = "SELECT * FROM test2";
       $results = mysql_query($query); //<-SO simply change to something else, ie $result2
}

[Blaze]

Yours won't work either (missing a ) on the while. Thanks for your help. I'll give that a try.