Re: Select statement

[Jochen Wiedmann]

mark o' sullivan wrote:

> completionDate, successMeasuredBy FROM waitingroom WHERE '$user =
> candidate'"); 

How about

    $user='candidate'

And, besides, read the secion on placeholders in the DBI manual. Note,
that your own name contains a single quote and will most likely break
the syntax when inserted into the database using that name. In other
words, better use

    $sth = $dbh->prepare("SELECT candidate,task, estimatedSize, approved,
                         completionDate, successMeasuredBy FROM waitingroom
                         WHERE ?='candidate'");
    $sth->execute($user);


Jochen