$query = 'select date, run_time, run_dis, num_push, num_sit, abs, comment, workout_id, scored from "cshaws_Schema"."log2" where pid = ' . $pid . ' order by date';

$sth = $dbh->prepare($query);
$sth->execute($query);
$sth->bind_columns(\$dates, \$run_time, \$run_dis, \$num_push, \$num_sit, \$abs, \$comment, \$workout_id, \$scored );
while($sth->fetch())
{
processes
}