Hi all,
I am having this common error and I don’t see why it is happening.
Here is my code:
[php]
session_start();
//CONNECT TO DATABASE//
$hostname = “abc”;
$username = “abc”;
$password = “abc”;
$db_name = “abc”;
$tbl_name = “accounts”;
$connect = mysql_connect($hostname,$username,$password);
if (!$connect)
{
die(“Connection to database failed.
” . " Please contact an Administrator and show them the code above.
");
}
//SELECT CORRECT DATABASE//
mysql_select_db("$db_name", $connect)or die(“Cannot select database.”);
////////////////////////
$currentusr = $_SESSION[‘usr’];
$currentema = $_SESSION[‘ema’];
$newbio = $_POST[‘changebio’];
$updatebio = mysql_query(“UPDATE accounts SET bio=’$newbio’ WHERE usr=’$currentusr’ AND ema=’$currentema’”);
if($updatebio)
{
header(Location:“http://www.blu-byte.co.cc/members/profile/edit.php”);
}
else
{
echo “Sorry about this but we have unsuccessfully changed your biography.”;
}
?>
[/php]What’s wrong with it?