From: Chris
Date: March 25 1999 2:39pm
Subject: Re: Extracting a given row using Perl API
List-Archive: http://lists.mysql.com/mysql/955
Message-Id: <Pine.LNX.4.04.9903250938390.2362-100000@hiro.studentadvantage.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII



Bill, try this:

my $sth = $dbh->prepare("SELECT first,last,phone FROM $table WHERE
phone_book.last='$FOO'");

You must ensure that there are quotes around $FOO.

--Chris

> my $sth = $dbh->prepare("SELECT first,last,phone FROM $table WHERE
> phone_book.last='Blow'");
> 
> works while the following does not;
> 
> my $sth = $dbh->prepare("SELECT first,last,phone FROM $table WHERE
> phone_book.last=$FOO");