echo mysql_error();
echo"<pre>";
var_dump($result);
// send a message to each e-mail address in the table
while ($row = odbc_fetch_array($result)) // also tried fetch_assoc
{
$email = $row['email'];
echo "mail to: <b>\$email</b>: $email<br>";
send_message($email, $subject, $message);
}
var_dump($row);
Because both those gave the same results as fetch_row. I notice that you're suggesting mysql fetch functions while I'm using odbc functions. Probably doesn't make a difference, but it's probably good to be aware of every detail. I'm gonna do a little experiement and see if I can get ANY data from the database with this script, even if it's not necessarily the data I want, because I have some other scripts using the same exact connection script and getting results. So don't worry about thinking too hard about this - I'll post again if my situation gets really desperate.
Well, I figured it out. Apparently it had something to do with the db connection. I never pinpointed the problem - I just started over from scratch out of frustration.