[RESOLVED] Mysql sytax error

[Megahertza]

I'm fairly new to mysql, i'm trying to select all rows with the username the user inputed.

$result = mysql_query("SELECT * FROM users WHERE username '$username'")
or die(mysql_error());

I get this mysql error.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Megahertza'' at line 1

Where am i going wrong. befor i was just using ("SELECT * FROM users")

[Roger_Ramjet]

You forgot the equals sign

$result = mysql_query("SELECT * FROM users WHERE username = '$username'")
or die(mysql_error());