i have a problem with my coding. when i put 'where' in my query, it does not show anything. but when i do not put 'where' it display all the records. all i want is that, it will display the records of the current user that logged in..

please help me with this.

what will be the code for these?

anyone? :(

it will be a big help. thanks..

This is my query..

```
$query="SELECT * FROM members where username = '$username'";
$result=mysql_query($query);
$num=mysql_numrows($result);  

```

whenever i put WHERE , it doesn't display anything.