$select = $db->prepare($sql); $select->execute(); $select->bind_columns(undef,\$var1,\$var2); while ($select->fetch) { print "$var1 $var2\n"; }