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