mysql syntax error

[gamma]

No, i think the error is because the username is empty, try

$username = $_SESSION['username']; 
$mysqlquery = mysql_query("SELECT * FROM members WHERE username='" . $username ."'"); 
if ($mysqlquery)
$fetch_users_data = mysql_fetch_object($mysqlquery);
else
die("username=" . $username . " mysql error=" . mysql_error()); 

Thanks a lot Moggy its working now love you

gamma Reviewed by gamma on 18th Apr 2012. mysql syntax error there's a syntax error in this mysql statement.. please help.. thanks a ton.. $fetch_users_data = mysql_fetch_object(mysql_query("SELECT * FROM 'members' WHERE username=".$_SESSION."")); ---------- Post added 16th Apr 2012 at 07:04 AM ---------- Previous post was 15th Apr 2012 at 11:38 AM ---------- bump Rating: 5