on Tue, 13 Aug 2002 18:36:10 GMT, Michael spellbrink wrote:

> Now I want to create select statements for $value in each of the
> result @table_name.
> something like that:
> 
> for ($i= 0; $i<@table_name; $i++)
> {
>     
>     my $sql2="select * from ? where ? = ?";
>     my $sth=$dbh->prepare($sql2);
>     $sth->execute($table_name[$i],$column_name,$value);
>     
> }

What's wrong with:

for ($i = 0; $i < @table_name; $i++) {
   my $sql2 = "SELECT * FROM $table_name[$i] WHERE $column_name[$i] = ?";
   my $sth=$dbh->prepare($sql2);     
   $sth->execute($value);
}

-- 
felix

Reply via email to