Защо не ми изкарва стринга?

[Montez]

<?php

//This will start a session
session_start();

$username = $_SESSION['username'];
$password = $_SESSION['password'];

//Check do we have username and password
if(!$username && !$password){
echo "Welcome Quest! <br> <a href=login.php>Login</a> | <a href=register.php>Register</a>";
}else{



echo "Welcome ".$username." (<a href=logout.php>Logout</a>)";
$qu = "SELECT ('pari') FROM 'users' WHERE username = '$username'"
or die (mysql_error());
$res = mysql_query($qu);
while ($r=mysql_fetch_array($res)) {
extract($r);
$pari = $r['pari']; 
}
echo "vie imate $pari";
}


?>

показва ми само

vie imate

 

[Fakeheal]

пробвай така

echo "vie imate".$pari;

 

[relax15pyt]

Научи какво прави extract(); ... махни го от цикъла, дори махни целия цикъл. За всеки потребител като вадиш поотделно не е нужно да минаваш през цикъл.

<?php 

//This will start a session 
session_start(); 

$username = $_SESSION['username']; 
$password = $_SESSION['password']; 

//Check do we have username and password 
if(!$username && !$password){ 
echo "Welcome Quest! <br> <a href=login.php>Login</a> | <a href=register.php>Register</a>"; 
}else{ 



echo "Welcome ".$username." (<a href=logout.php>Logout</a>)"; 
$qu = "SELECT ('pari') FROM 'users' WHERE username = '$username'" 
or die (mysql_error()); 
$res = mysql_query($qu); 
$r=mysql_fetch_array($res); 
$pari = $r['pari'];  
echo "vie imate $pari"; 
} 


?>

 

[Montez]

Не става момчета

 

[relax15pyt]

Вади ли ти грешка или нещо ?

 

[Montez]

не

 

[Montez]

не

 

[Karcho]

echo "Welcome ".$username." (<a href=logout.php>Logout</a>)";
$qu = "SELECT pari FROM `users` WHERE username = '$username'"
or die (mysql_error());
$res = mysql_query($qu);
$r=mysql_fetch_array($res);
$pari = $r['pari'];
echo "vie imate $pari";
}