PHP and MySQL database!

[someonewhois]

Ok, I tried that and now get the following at signup.php:

Parse error: parse error in /path/path/path/db.php on line 17

Any ideas?

[someonewhois]

Now what?

[someonewhois]

Nothing?

[sleepless]

what's that line 17?

[someonewhois]

Line 17 is:

mysql_select_db($db, $dbcnx); or die(mysql_error());

Any ideas? :O

[sleepless]

remove ; before or

mysql_select_db($db, $dbcnx) or die(mysql_error()); 

[someonewhois]

Ok, did that, but when I try and register I still get:

No Database Selected

ANy ideas at this?

[someonewhois]

Ok, before somebody said to add a line into the places about $db..

So is my db.php suppoed to be like this:

<?php // db.php

$dbhost = "localhost";
$dbuser = "coaster_coastert";
$dbpass = "********";

function dbConnect($db="coaster_coasterthrills") {
$db = "coaster_coasterthrills"; 

    global $db,$dbhost,$dbuser,$dbpass;

    

    $dbcnx = mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());


    mysql_select_db($db, $dbcnx) or die(mysql_error());

    

    return $dbcnx;
}

?>

Like this:

<?php // db.php

$dbhost = "localhost";
$dbuser = "coaster_coastert";
$dbpass = "********";

function dbConnect($db="") {
$db = "coaster_coasterthrills"; 

    global $db,$dbhost,$dbuser,$dbpass;

    

    $dbcnx = mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());


    mysql_select_db($db, $dbcnx) or die(mysql_error());

    

    return $dbcnx;
}

?>

Or like this:

<?php // db.php

$dbhost = "localhost";
$dbuser = "coaster_coastert";
$dbpass = "********";

function dbConnect($db="coaster_coasterthrills") {

    global $db,$dbhost,$dbuser,$dbpass;

    

    $dbcnx = mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());


    mysql_select_db($db, $dbcnx) or die(mysql_error());

    

    return $dbcnx;
}

?>

I'm not sure which one I should use... right now I use teh first one!

[someonewhois]

Should I get the zips over now that the MySQL works and just use that?

That I will try, it might work! :P

[someonewhois]

Ok, after waiting and waiting for ever for responds here (and thank you for doing so after the worth while wait) I finally got it working!

I think I did so much changing trying to get the MySQL to work, that I f'ed everything up!

So, I got the files out of the zip again, and put the right details that I finally have, and it works!

Thanks for everything all!
~someonewhois

[GlobalFusion]

Dont you just hate when you have code that 'should' work, but doesnt?