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..
