Mysql

[RyanDOT]

Parse error:  syntax error, unexpected ';' in /home/sitename/public_html/panel/connect.php on line 10 

I get that error on Radio DJ Panel

I typed in the mysql details

How to fix it?

Im rubbish at mysql...

+Rep

[Agnostic Bear]

Has nothing to do with MySQL, it's a php error, post connect.php code.

[RyanDOT]

<?

//set local variables
$dbhost ="localhost"; //Database Host
$dbuser ="sitename_????"; //Database User
$dbpass ="sitename_????"; //Database Password
$dbname ="sitename_????"; //Database Name

//connect 
$db =mysql_pconnect($dbhost,$dbuser,$dbpass; 
mysql_select_db($dbname,$db;

?>

[scottish]

you never closed the bracket on mysql select db...

also should be a space after the = on line before

[Jack!]

Try This Edit what is blue to you DB details

<?

//set local variables
$dbhost ="localhost"; //Database Host
$dbuser ="Username"; //Database User
$dbpass ="Password"; //Database Password
$dbname ="Database Name"; //Database Name

//connect

$db =mysql_pconnect($dbhost,$dbuser,$dbpass;
mysql_select_db($dbname,$db )

?>

[RyanDOT]

you never closed the bracket on mysql select db...

also should be a space after the = on line before

Try This Edit what is blue to you DB details

<?

//set local variables
$dbhost ="localhost"; //Database Host
$dbuser ="Username"; //Database User
$dbpass ="Password"; //Database Password
$dbname ="Database Name"; //Database Name

//connect

$db =mysql_pconnect($dbhost,$dbuser,$dbpass;
mysql_select_db($dbname,$db )

?>

Did that, still the same error!

[scottish]

End of the both lines after //connect

you need the close the bracket

so it'd be


$db = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname,$db) ;

[RyanDOT]

End of the both lines after //connect

you need the close the bracket

so it'd be


$db = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname,$db) ;

Oh thanks, im dumb at mySQL.

Thanks!

[iUnknown]

Change code to:

<?

//set local variables
$dbhost ="localhost"; //Database Host
$dbuser ="sitename_????"; //Database User
$dbpass ="sitename_????"; //Database Password
$dbname ="sitename_????"; //Database Name

//connect 
$db =mysql_pconnect($dbhost,$dbuser,$dbpass); 
mysql_select_db($dbname,$db);

?>

[DeejayMachoo$]

Oh thanks, im dumb at mySQL.

Thanks!

Its PHP not mySQL. Your connecting too a mySQL database through PHP code, it was the PHP that had the error.