Indie-Resource.com

Code: Select all

$db = mysql_connect("localhost","root","") or die("Could not connect to db");
if(!$db)
 die("no db");
if(!mysql_select_db("ssg",$db))
 die("No Database Selected");

Code: Select all

$db = mysql_connect("localhost","root","") or die("Could not connect to db");
if(!$db)
 die("no db");
if(!mysql_select_db("lqotl",$db))
 die("No Database Selected");

Code: Select all

$query = "select * from players where username='$username' ";
  $result = mysql_query($query) or die("Could not find user in players");
  $result2 = mysql_fetch_array($result);
  if (!$result2) {
	  	$regdate=$date=(date("Y/m/d"));	  
	  	$SQL = "INSERT into players (name, access, cssset, regdate,) VALUES ('$username','1','1','$regdate')";
		mysql_query($SQL) or die("could not register player");
		header("Location: playermade.php");	  
	   }
	   else {
	$lqlotlid = $result2['id'];
	$player = $result2['name'];
	$lqloflaccess =  $result2['access'];
	$cssset = $result2['cssset'];
	$regdate =  $result2['regdate'];
	$charslot1 = $result2['chars1'];
	$charslot2 = $result2['chars2'];
	$charslot3 = $result2['chars3'];	
	$charslot4 = $result2['chars4'];
	$charslot5 = $result2['chars5'];
	$charslot6 = $result2['chars6'];
			}

Code: Select all

$ssg = mysql_connect('localhost','root');
mysql_select_db('ssg', $ssg);

$lqo = mysql_connect('localhost','root');
mysql_select_db('lqotl', $lqo); 

$query = mysql_query("SELECT * FROM players WHERE username='$username'", $ssg); 
$query2 = mysql_query("SELECT * FROM table WHERE field='lol'", $lqo); 
 

Code: Select all

mysql_connect('localhost','root');
$query = mysql_query("SELECT * FROM `ssg`.`players` WHERE `username` = '$username'");