parse error

[crawfd]

Why am I getting a parse error with the first line of this query

$query = mysql_query("Select username FROM $table WHERE username = "'.$_SESSION['username'].'" order by date DESC",$db);

[LordShryku]

Because you have your quotes backwards here:
"'.$_SESSION['username'].'"

[DigitHeads]

or try this-

<?

SQL = "Select username FROM $table WHERE username= '$_SESSION[username]' order by date DESC";
$result=mysql_query($SQL, $db);

?>

[crawfd]

My quotes are backwards? where? None of these worked...:-/

[LordShryku]

Look at the difference in single quotes/double quotes. You use double quotes to surrond the query, but try to concatenate with single quotes.

// Current 
$query = mysql_query("Select username FROM $table WHERE username = "'.$_SESSION['username'].'" order by date DESC",$db);

// Correct
$query = mysql_query("Select username FROM $table WHERE username = '".$_SESSION['username']."' order by date DESC",$db);

[crawfd]

got it thanks......