Re: MySQL

[screamingeagle]

you're enclosing the column names and the table names in single quotes. try removing them ...and add the where clause like stajich suggested :

$sth = $dbh->prepare("SELECT username,password,group FROM users where 
+group = 'Admin'");
 $sth->execute;

In SQL Server, the check is not case-sensitive, however , if you're using oracle, you might want to write the SQL Stmt like this :

SELECT username,password,group FROM users 
where upper(group) = upper('admin')

hth...