PHP/MYSQL help needed....please.

[gom]

I am very new to this, and I could really appreciate any help.

I created a database called "mwalid_database". The username is "mwalid_user". The database password is "password". The main user is "commish".

My localhost address is "mysql30.ixwebhosting.com"

Here is the original file I am to edit:

<?
$db_user = "DBUSER";
$db_pass = "DBPASS";
$db_mysql = "DBNAME";
$main_user = "ADMIN USER";
if (!defined('NUKE'))
define('NUKE',0);
// Added to see if we are using PhP Nuke or not
if (constant("NUKE")==0)
{
$dbi=mysql_connect ("localhost", "$db_user", "$db_pass");
mysql_select_db ("$db_mysql",$dbi);
}
else
{
require_once("mainfile.php");
}
global $prefix, $dbi;
?>

I am not using nuke.

As far as I can see, I made the following changes:

<?
$db_user = "mwalid_user";
$db_pass = "password";
$db_mysql = "mwalid_database";
$main_user = "commish";
if (!defined('NUKE'))
define('NUKE',0);
// Added to see if we are using PhP Nuke or not
if (constant("NUKE")==0)
{
$dbi=mysql_connect ("mysql30.ixwebhosting.com", "mwalid_user", "password");
mysql_select_db ("mwalid_database",$dbi);
}
else
{
require_once("mainfile.php");
}
global $prefix, $dbi;
?>

I am able to create users, but no attempts at logging in, either by creating a normal or superuser, makes any difference. I get a login un-successful every time. The URL for the website is www.talksoxbbl.com/bosi/standings.php?lid=#

If anyone can post/email or IM me at AOL sith712, I'd appreciate it. TIA.

[Xnuiem]

Change:

$dbi=mysql_connect ("mysql30.ixwebhosting.com", "mwalid_user", "password");
mysql_select_db ("mwalid_database",$dbi);

to

$dbi=mysql_connect ("localhost", "mwalid_user", "password") or die("FAILED MYSQL CONNECT");
mysql_select_db ("mwalid_database",$dbi) or die("COULD NOT SELECT DATABASE");

That way you can see if this is actually the issue. It doesnt sound like this area is the problem.

[gom]

This is what I get:

FAILED MYSQL CONNECT

So it's obvious I'm not getting a mysql connection, but I don't understand how to fix it.

[gom]

The problem was, I found out, that the sessions on the windows server were not holding. I switched it over to a linux server, and it worked perfectly.

Thanks for your help, either way. I appreciate it.

[Xnuiem]

LOL. And people wonder why i love linux.

Glad you got it working, and thanks for posting your solution. Always good to know what worked even if it wasnt my idea.