PDO Query question

Question

I need help finishing this statement. It is frustrating that two of the PHP phone books here gloss over PDO's almost all together.

All I need to do is check the database for a username that is already taken.

Here is the start of the statement.

$sql = " SELECT * FROM users WHERE userid = '$userid'";
$result = $dbh->query($sql);

What parts do I need to add to write my 'if' statement?

Answer 1

Something like this:

$sql = " SELECT * FROM users WHERE userid = '$userid'";
$result = $dbh->query($sql);
$row = $result->fetch();

if ($row)
    echo 'Userid is taken';

I'm not sure about your question because you're asking about username but selecting userid... did you mean to select on username?