help with mysql

[ccalzaretta]

Need database help please trying to connect to 2 databases at the same time
on the same page

here are the connect codes

$name1 = $name;
$pass1 = $pass;
$mysql = mysql_connect( "ip, 'username', 'password' );
$db = mysql_select_db("Domain");
$query23 = "select from Login where Uname ='$name1' and Upass = password('$pass1')";
$result23 = mysql_query($query23, $mysql);
if ($result23)
{
$row23 = mysql_fetch_array($result23);
$rs= $row23["DomainName"];
$rs_array = explode(".", $rs);
$rs_array[1] = "inc";
$includeit = join(".", $rs_array); session_register("name1");
session_register("pass1");
include("Stats/$includeit");
setcookie("name");
setcookie("pass");
mysql_close($mysql);
}
$mysql = mysql_connect( "ip, 'username', 'password' );
$db = mysql_select_db("Shopitnexflo", $mysql);
$query2 ="select from steps";
$result2 = mysql_query($query2, $mysql);
if ($result2)
{
$crow = mysql_fetch_array($result2);
$cvar = $crow["step1"];
}

you can test it at
www.nexflo.com/newsite/phpscripts/login.php
username
tester
password
tester
click on site management... That is where all my sql errors are..

[Anon]

Okay, first of all I'm not clear on the exact intent of your question. Do you want to connect to two databases simultaneously? If so, here is what you need to do:

$link1 = mysql_connect($host1, $username1, $password1);
$link2 = mysql_connect($host2, $username2, $password2);

Then every time you invoke another mysql function, pass the link.

For example, if you want select database on $link1, do this:

mysql_select_db("database", $link1);

Every mysql function has an argument called "resource [link_identifier]". Refer to the manual to find out where this argument goes.

-sridhar