Hi,

I don't understand nothing with SQL.
I do this
$dbh= DBI->connect..............

$sth=$dbh->prepare(qq(SELECT longitude, latitude FROM place WHERE
userid='?')) or die...;
$sth->execute($userid) or die..;

I also done this
$sth=$dbh->prepare(qq(SELECT longitude, latitude FROM place WHERE
userid=$userid)) or die...;
$sth->execute() or die..;

And redid the statment above with double quotes around $userid i.e
"$userid";
And in ALL cases i get
DBD::mysql::st execute failed: Unknown column 'ant284' in 'where clause' at
search.pl line 121.
**where ant284 is my userid**

Where is the problem in all those statments??

thanx for any help
Anthony


Reply via email to