Variable after WHERE

[DaedalusShadow]

I've got a piece of script that works that looks like this:
__________________________________________________ _________

$username="daedalus_admin";
$password="test";
$database="daedalus_db";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query="SELECT * FROM user WHERE username='daedalus";
$result=mysql_query($query);

$num=mysql_numrows($result);
__________________________________________________ _________

I want to change it to this so that I can use a variable from a session at a later date:
__________________________________________________ _________

$schque="daedalus"

$username="daedalus_admin";
$password="test";
$database="daedalus_db";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query="SELECT * FROM user WHERE username='$schque";
$result=mysql_query($query);

$num=mysql_numrows($result);
__________________________________________________ _________

But as soon as I change the criteria of the WHERE to $schque the page stops working and comes up blank, i've tried it without the ' round it but it still doesn't work, I'm really confused any help would be appriecated.

[mainul]

I've got a piece of script that works that looks like this:
__________________________________________________ _________

$username="daedalus_admin";
$password="test";
$database="daedalus_db";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query="SELECT * FROM user WHERE username='daedalus";
$result=mysql_query($query);

$num=mysql_numrows($result);
__________________________________________________ _________

I want to change it to this so that I can use a variable from a session at a later date:
__________________________________________________ _________

$schque="daedalus"

$username="daedalus_admin";
$password="test";
$database="daedalus_db";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query="SELECT * FROM user WHERE username='$schque";
$result=mysql_query($query);

$num=mysql_numrows($result);
__________________________________________________ _________

But as soon as I change the criteria of the WHERE to $schque the page stops working and comes up blank, i've tried it without the ' round it but it still doesn't work, I'm really confused any help would be appriecated.

use

$a=$_REQUEST['$schque'];
$query="SELECT * FROM user WHERE username='$a'";

[DaedalusShadow]

use

$a=$_REQUEST['$schque'];
$query="SELECT * FROM user WHERE username='$a'";

Thanks this works perfectly, I owe you one.

[mainul]

You are welcome.