My login System is not working

[ATM]

Hey, I'm trying to make a login system using php, firstly I have a form which submits the submitted username and password, this will also be used to connect to the database as the user will have there limited mysql account. I also have the database it's self which I have set up using the same username and password as my mysql. However this is not working so I'm wondering if you can help me find out what is wrong with this code:

<?php/*Mysql Details*/$mysql_username=$_POST["username"];$mysql_password=$_POST["password"];$mysql_servername="*****";$mysql_database="*****";/*General Table*/$mysql_fieldname_user_id="user_id";/*Login Table*/$mysql_tablename_login="login";$mysql_fieldname_username="username";$mysql_fieldname_password="password";/*Personal Information Table*/$mysql_tablename_personal_information="personal_information";$mysql_fieldname_title="title";$mysql_fieldname_first_name="first_name";$mysql_fieldname_surname="surname";$mysql_fieldname_company="company";$mysql_fieldname_street_address="street_address";$mysql_fieldname_town="town";$mysql_fieldname_county="county";$mysql_fieldname_country="country";$mysql_fieldname_postcode="postcode";$mysql_fieldname_email_address="e-mail_address";$mysql_fieldname_telephone_number="telephone_number";$mysql_fieldname_website="website";/*Account Details Table*/$mysql_tablename_account_details="account_details";$mysql_fieldname_account_type="account_type";$mysql_fieldname_xml_reference="xml_reference";$mysql_fieldname_xml_version="xml_version";$mysql_fieldname_date_created="date_created";$mysql_fieldname_last_login="last_login";/*Fail Function*/function Fail()  {  header('Location: http://www.designs.rymax.co.uk/');  exit();  }/*Mysql Connect*/$connect=@mysql_connect($mysql_servername,$mysql_username,$mysql_password);if(!$connect){Fail();}/*Mysql Username Query*/$mysql_username_query=mysql_query("SELECT * FROM ".$mysql_tablename_login." WHERE ".$mysql_fieldname_username."='".$username."'");$fetch_array_login=@mysql_fetch_array($mysql_username_query);if(!@mysql_fetch_array($fetch_array_login)){Fail();}/*Verify Password*/$verify=$fetch_array_login[$mysql_fieldname_password];if(!$verify==$password){Fail();}/*Get User ID*/$user_id=$fetch_array_login[$mysql_fieldname_user_id];/*Mysql Personal Information Query*/$mysql_personal_information_query=mysql_query("SELECT * FROM ".$mysql_tablename_personal_infomation." WHERE ".$mysql_fieldname_user_id."='".$user_id."'");$fetch_array_personal_information=@mysql_fetch_array($mysql_personal_information_query);/*Mysql Account Details Query*/$mysql_account_details_query=mysql_query("SELECT * FROM ".$mysql_tablename_account_details." WHERE ".$mysql_fieldname_user_id."='".$user_id."'");$fetch_array_account_details=@mysql_fetch_array($mysql_account_details_query);/*Get Personal Information*/$title=$fetch_array_personal_information[$mysql_fieldname_title];$first_name=$fetch_array_personal_information[$mysql_fieldname_first_name];$surname=$fetch_array_personal_information[$mysql_fieldname_surname];$company=$fetch_array_personal_information[$mysql_fieldname_company];$street_address=$fetch_array_personal_information[$mysql_fieldname_street_address];$town=$fetch_array_personal_information[$mysql_fieldname_town];$county=$fetch_array_personal_information[$mysql_fieldname_county];$country=$fetch_array_personal_information[$mysql_fieldname_country];$postcode=$fetch_array_personal_information[$mysql_fieldname_postcode];$email_address=$fetch_array_personal_information[$mysql_fieldname_email_address];$telephone_number=$fetch_array_personal_information[$mysql_fieldname_telephone_number];$website=$fetch_array_personal_information[$mysql_fieldname_website];/*Get Account Details*/$account_type=$fetch_array_personal_information[$mysql_fieldname_account_type];$xml_reference=$fetch_array_personal_information[$mysql_fieldname_xml_reference];$xml_version=$fetch_array_personal_information[$mysql_fieldname_xml_version];$date_created=$fetch_array_personal_information[$mysql_fieldname_date_created];$last_login=$fetch_array_personal_information[$mysql_fieldname_last_login];/*Edit Data*/if($title==1){unset($title);$title="Mr";}elseif($title==2){unset($title);$title="Mrs";}elseif($title==3){unset($title);$title="Miss";}elseif($title==4){unset($title);$title="Ms";}else{unset($title);$title=$first_name;}/*Start Session*/session_start();/*Write Session Variables*/$_SESSION['login']="true";$_SESSION['user_id']=$user_id;$_SESSION['title']=$title;$_SESSION['first_name']=$first_name;$_SESSION['surname']=$surname;$_SESSION['company']=$company;$_SESSION['street_address']=$street_address;$_SESSION['town']=$town;$_SESSION['county']=$county;$_SESSION['country']=$country;$_SESSION['postcode']=$postcode;$_SESSION['email_address']=$email_address;$_SESSION['telephone_number']=$telephone_number;$_SESSION['website']=$website;$_SESSION['account_type']=$account_type;$_SESSION['xml_reference']=$xml_reference;$_SESSION['xml_version']=$xml_version;$_SESSION['date_created']=$date_created;$_SESSION['last_login']=$last_login;/*Verify Account Type*/if($account_type=="1"){header('Location: *****');exit();}else{header('Location: *****');exit();}?>

Thanks,

[justsomeguy]

You need to find out where it is failing. Use echo statements to determine at which point it is failing, and have it display the result of mysql_error() to see what the problem is.

[pulpfiction]

What kind of error are you getting, post the error msg. it might be helpful...

[ATM]

I've fixed it now, thanks