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