I have a question about error-handling and my WHILE loop.
First, here is the code for my query...
$q8 = "SELECT COALESCE(m.username,'Non-Member') AS username
FROM visitor_log AS v
LEFT OUTER JOIN member AS m
ON m.id = v.visitor_id
ORDER BY v.created_on DESC
// Prepare statement.
$stmt8 = mysqli_prepare($dbc, $q8);
// Bind variable to query.
mysqli_stmt_bind_param($stmt8, 'i', $memberID);
// Execute query.
// Store results.
// Check # of Records Returned.
// Visitors Found.
// Bind result-set to variables.
// Fetch below in loop...
// Visitors Not Found.
// Do Nothing...
And then here is the loop I am concerned about...
// Loop through Friends.
//Some code here...
I am worried that if my query (i.e. mysqli_stmt_fetch($stmt8))) returns "0" or "NULL" that my loop could go crazy?!
For a preliminary test, I changed my query to LIMIT 0, and my loop seemed to be okay, but I still feel like something is missing...