View Single Post
Old 02-17-2008, 11:32 AM   #11 (permalink)
falsepride
Regular Contributor
 
Join Date: Oct 2004
Posts: 215
falsepride is on a distinguished road
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
falsepride is offline   Reply With Quote