Mysql Query Problem

[davt55]

Cannot retrieve database records and cannot display results on web page. I do not get an error. Must be something simple that I am not doing. If someone can help I would greatly appreciate it. Here is the code:
$query = "SELECT * FROM mychessbuddies ORDER BY chapter, lastname LIMIT 100";
$result = mysql_query($dbc, $query) or die('Could not connect' . mysqli_error());
echo mysql_num_rows($result);
If (!$result) {
$message = 'Invalid query: ' . mysqli_error() , "\n";
$message = 'Whole query: ' . $query;
die ($message);
}

while($row = mysql_fetch_assoc($result)) {
echo $row['firstname'] . " " . $row['lastname'] . $row['chapter'] . "\n";
}
mysql_free_result($result);
mysql_close($dbc);
?>

[NogDog]

This line has a comma where you want a period:

$message = 'Invalid query: ' . mysqli_error() , "\n";
                                            //|\\

[Pikachu2000]

You're mixing mysql and mysqli extensions. Pick one or the other and stick with it, as they are not interoperable, and use somewhat different syntax.