[Mysticales]

Yea I have the site www.qj.net which we have on a seperate server from the forums, which means the main site and the forums wont BE on the same host and ftp. So meaning, the main site would 1st need to call the data off the SQL tables I assume, then apply it.

I would assume all one needs to use is the command in a php page for.

<?php
mysql_connect('sql server', 'user', 'password');
?>

Would that be all thats needed? Then remove the chdir line from the codes calling it?

I mean what would you think? Cause its not a matter of cross site on same host, its about crossing onto a different host server with same domain ending.

Edit:

After more studies.. I wonder if somehow we can replace the local path settings with a remote SQL calling. (Which I know sadly requires a IP for the sql server which I dont know if thats really easy to setup with most hosts)

// connect
$cs = mssql_connect ( 'server_name:port', 'username', 'password' ) or die ( 'Can not connect to server' );

// select
mssql_select_db ( '[database_name]', $cs ) or die ( 'Can not select database' );

//query
$sql = "SELECT * FROM [TABLENAME]";
$r = mssql_query ( $sql, $cs ) or die ( 'Query Error' );

// loop the result

while ( $row = mssql_fetch_array ( $r ) )
{
	/* do stuff */
}

Would be a idea for the remote calling. Unless somehow... there is a way to do cross server calling easier for vB access and database checking?