Basic Select Statement Issue.

[mhoctober]

All...

can anyone see anything wrong with this sql statement? I am getting no rows returned despite the fact that I have a record that meets the criteria.

$sQuery="SELECT * FROM tblPeople where 'fldPersonemail' = '[e-mail]' ";

Many thanks

[Anyango]

try

$sQuery="SELECT * FROM tblPeople where fldPersonemail = '[e-mail]' ";