php error

[ma5ect]

Hi ppl..

 

 

i have a website setup and a database running with it, everything works fine on my desktop pc and now i am trying to get it working on my laptop..

 

but i get the following error when running the website

 

could any1 plz suggest something

 

error:Warning: mysql_pconnect() expects parameter 4 to be long, string given in C:\xampp\htdocs\checklogin.php on line 9

 

Fatal error: in C:\xampp\htdocs\checklogin.php on line 9

 

many thanks

[Bendude14]

can we see line 9 and a bit of the code?

[ma5ect]

sure...

 

$mysql_connect = mysql_pconnect($hostname_mysql_connect, $username_mysql_connect, $password_mysql_connect, $tblname_mysql_connect) or trigger_error(mysql_error(),E_USER_ERROR);

mysql_select_db($database_mysql_connect) or die(mysql_error());

 

 

[PFMaBiSmAd]

The posted code never worked, because the 4th parameter in the mysql_pconnect() is not a table name, which is what your variable name is implying - $tblname_mysql_connect

[ma5ect]

check login file:

 

<?

$hostname_mysql_connect = "localhost";
$database_mysql_connect = "website_members";
$username_mysql_connect = "root";
$password_mysql_connect = "******";
$tblname_mysql_connect ="members";

$mysql_connect = mysql_pconnect($hostname_mysql_connect, $username_mysql_connect, $password_mysql_connect, $tblname_mysql_connect) or trigger_error(mysql_error(),E_USER_ERROR); 
mysql_select_db($database_mysql_connect) or die(mysql_error());

$myusername = $_POST['myusername'];
$mypassword = $_POST['mypassword'];

$sql = "SELECT * FROM $tblname_mysql_connect WHERE username= '$myusername' and passwords='$mypassword'"; 
$result = mysql_query($sql) or die(mysql_error());

$count = mysql_num_rows($result);

if($count==1) {
session_register("myusername");
session_register("mypassword");
header("location: login_success_welcome.php");
}
else {
echo "Wrong Username or Password";
}

?>

[ma5ect]

but i do have that table in the database.. it does exist

[PFMaBiSmAd]

The only way you can use a programming language effectively is if you read the documentation for the functions you are using - http://us3.php.net/mysql_pconnect

 

The 4th parameter, which the error message and I have both told you is incorrect, it is not a table name.

[ma5ect]

when i test the databse with the website it successfully connects and displays all the tables..

 

cud you suggest another method of connecteing the database with the website..

[ma5ect]

got it working

 

thanks 4 all da help