Jump to content

Changed database context to 'databasename'


aebstract

Recommended Posts

<?php

$query =
mssql_query("

SELECT UserID
FROM ordnn_Forum_Posts


");




if(mssql_num_rows($query) > 0){
while($r=mssql_fetch_array($query)){


echo "<pre>";
print_r($r);
echo "</pre>";


}
} else {
echo mssql_get_last_message();
}


?>

 

Okay, I'm just trying to simply grab and display the UserID from ordnn_Forum_Posts. I'm getting this error:

Changed database context to 'outlawracingcom'.

 

 

I've looked around a little bit and noticed some references saying it is just a message not an actual error. If this was the case, I would be able to at least see/get my information. I just get the error and a white page to follow it.

Link to comment
Share on other sites

I'm connected, if I wasn't connected the first thing is it wouldn't be saying 'outlawracingcom' because it wouldn't have a connection to pull that value.

 

This is at the top:

$server = 'ww26.empiredatatech.com';
$link = mssql_connect($server, 'user', 'pass');

Which, no it isn't using mssql_select_db(), but this code below works perfect:

 

<?php

$server = 'ww26.empiredatatech.com';
$link = mssql_connect($server, 'outlaw', 'out98765law');




$query =
mssql_query("

SELECT ordnn_Users.userid, ordnn_Users.username, ordnn_Users.email, ordnn_UserPortals.CreatedDate
FROM ordnn_Users
JOIN ordnn_UserPortals ON ordnn_Users.userid = ordnn_UserPortals.userid

");




if(mssql_num_rows($query) > 0){
while($r=mssql_fetch_array($query)){

$r[] = '00000000006xrqeiww
i1cjyo000000
qlaq52000000
qlaq52000000';

$r[] = crc32(strtolower($r[2])) . strlen($r[2]);

$r[0] = $r[0]+200;
echo "<pre>";
print_r($r);
echo "</pre>";


}
} else {
echo mssql_get_last_message();
}


?>

 

 

 

 

edit:

$server = 'ww26.empiredatatech.com';
$link = mssql_connect($server, 'user', 'pass');
mssql_select_db('outlawracingcom', $link);

 

This doesn't change the error one bit :(

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.