[PHP/SQL] Logged niet in (Opgelost)

$_POST['username']

$_POST['username']

$query = mysql_query('SELECT pid, password FROM shibble_profile WHERE username = '.$_POST['username'].'') or die(mysql_error());

$query = mysql_query('SELECT pid, password FROM shibble_profile WHERE username = '.$_POST['username'].'') or die(mysql_error());

<?php
mysql_query("SELECT pid, username, password FROM shibble_profile WHERE username = '".$_POST['username']."'") or die(mysql_error());
?>

<?php
mysql_query("SELECT pid, username, password FROM shibble_profile WHERE username = '".$_POST['username']."'") or die(mysql_error());
?>

<?php

$sql = "
  SELECT 
    pid, 
    username 
  FROM
    shibble_profile
  WHERE
      username = '".mysql_real_escape_string($_POST['username'])."'
	AND password = '".mysql_real_escape_string(md5($_POST['password']))."'
  LIMIT 1";
if(!$query = mysql_query($sql)){
	// Shit een foutje in de query!
}
else {
	
	// 1 resultaat
	if(mysql_num_rows($query) == 1){
	
		// Yes alles goed!
		$assoc = mysql_fetch_assoc($query);
		
		// Het wachtwoord opslaan? laten we dat maar niet doen!
		//setcookie('shibble_login', $password, time() + 60 * 60 * 24 * 7 * 54);
		
		$_SESSION['shibble_id'] = $assoc['pid'];
		header ('Location: index.php');
		exit();
	}
	else 
		
		// Mismatch
		$tpl = new TemplatePower('blocks/users/login.tpl');
		$tpl->prepare();
		$tpl->newBlock('error');
	}
}

?>

<?php
 
$sql = "
  SELECT 
    pid, 
    username 
  FROM
    shibble_profile
  WHERE
      username = '".mysql_real_escape_string($_POST['username'])."'
	AND password = '".mysql_real_escape_string(md5($_POST['password']))."'
  LIMIT 1";
if(!$query = mysql_query($sql)){
	// Shit een foutje in de query!
}
else {
 
	// 1 resultaat
	if(mysql_num_rows($query) == 1){
 
		// Yes alles goed!
		$assoc = mysql_fetch_assoc($query);
 
		// Het wachtwoord opslaan? laten we dat maar niet doen!
		//setcookie('shibble_login', $password, time() + 60 * 60 * 24 * 7 * 54);
 
		$_SESSION['shibble_id'] = $assoc['pid'];
		header ('Location: index.php');
		exit();
	}
	else 
 
		// Mismatch
		$tpl = new TemplatePower('blocks/users/login.tpl');
		$tpl->prepare();
		$tpl->newBlock('error');
	}
}
 
?>