that query was generated using phpMyAdmin. no idea what backticks are. anyway i made my table using
Code:
CREATE TABLE `managers` (
`name` VARCHAR( 50 ) NOT NULL ,
`password` VARCHAR( 50 ) NOT NULL ,
`webmaster` ENUM( 'false', 'true' ) NOT NULL ,
PRIMARY KEY ( `name` )
) TYPE = MYISAM ;
now i am having trouble querying my table,
Code:
$result = mysql_query("SELECT * FROM managers WHERE name=$username");
where $username is provided end user from a form. i tried replacing $username with an a constant value, and still got no results