View_Users.php Script 10.4

[skeery2605]

Im having trouble the script running correctly. Im getting one error on two different lines. Everything seems to be correct.
 
 
This the error Im getting on line 50 and 63.
(lines with errors highlighted in red)
 
mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in.[/size]
 
 
 
 
<?php # Script 10.4 - view_users.php #4
 
$page_title = 'View the Current Users';
 
include ('includes/header.html');
echo '<h1>Registered Users</h1>';
 
require_once ('mysqli_connect.php');
 
$display = 10;
 
if (isset($_GET['p']) && is_numeric($_GET['p'])) {
$pages = $_GET['p'];
} else {
$q = "SELECT COUNT(user_id) FROM users";
$r = @mysqli_query ($dbc, $q);
$row = @mysqli_fetch_array ($r, MYSQLI_NUM);
$records = $row[0];
 
if ($records > $display) { // More than one page.
$pages = ceil ($records/$display);
 
} else {
$pages = 1;
}
 
} // End of p IF.
 
if (isset($_GET['s']) && is_numeric
($_GET['s'])) {
$start = $_GET['s'];
} else {
$start = 0;
}
 
$q = "SELECT last_name, first_name, DATE_FORMAT(registration_date, '%M %d, %Y) AS dr user_id FROM users ORDER BY registration_date ASC LIMIT $start, $display";
$r = @mysqli_query ($dbc, $q);
 
echo '<table align="center" cellspacing="0" cellpadding="5" width="75%">
<tr>
<td align="left"><b>Edit</b></td>
<td align="left"><b>Delete</b></td>
<td align="left"><b>Last Name</b></td>
<td align="left"><b>First Name</b></td>
<td align="left"><b>Date Registered</b></td>
</tr>';
 
$bg = '#eeeeee';
 
while ($row = mysqli_fetch_array ($r, MYSQLI_ASSOC)) {
$bg = ($bg=='#eeeeee' ? '#ffffff' : '#eeeeee');
 
echo '<tr bgcolor="' . $bg . '">
<td align="left"><a href="edit_user.php"?id=' . $row['user_id'] . '">Edit</a></td>
<td align="left"><a href="delete_user.php?id=' . $row['user_id'] . '">Delete</a></td>
<td align="left">' . $row['last_name'] . '</td>
<td align="left">' . $row['first_name'] . '</td>
<td align="left">' . $row['dr'] . '</td>
</tr>
';
}
echo '</table>';
mysqli_free_result($r);
mysqli_close($dbc);
 
if ($pages > 1) {
echo '<br /><p>';
 
$current_page = ($start/$display) + 1;
 
if ($current_page !=1) {
echo '<a href="view_users.php?s=' . ($start - $display) . '&p=' . $pages . '">Previous</a> ';
 
}
 
for ($i = 1; $i <= $pages; $i++) {
if ($i != $current_page) {
echo '<a href="view_users.php?s=' . (($display * ($i - 1))) . '&p=' . $pages . '">' . $i . '</a> ';
} else {
echo $i . ' ';
}
}
if ($current_page != $pages) {
echo '<a href="view_users.php?s=' . ($start = $display) . '&p=' . $pages . '">Next</a>';
}
 
echo '</p>';
} // End of Link Section.
include ('includes/footer.html');
?>

[HartleySan]

Those errors are very likely a result of your query being invalid.

Try running the query directly on the DB, and if that's okay, echo out the values of the variables used in the query to ensure that those are being set to what you expect.

[skeery2605]

Ive got it going now. I missed two comma. i looked over them everytime i was looking to find errors

[HartleySan]

Well done.

Thanks for sharing.