This is in PHP, tying SQL into this. Keep getting this error caught TypeError: mysqli_fetch_array(): Argument #1
Fantastic news! We've Found the answer you've been seeking!
Question:
This is in PHP, tying SQL into this. Keep getting this error "caught TypeError: mysqli_fetch_array(): Argument #1 ($result) must be of type mysqli_result, bool given" this is talking about the line where the while statement is indicated
while($row = mysqli_fetch_array($query,MYSQLI_ASSOC))
{
echo ""; ";
echo "" . $CUST_ID . " ";
echo "" . $row['name'] . " ";
echo "" . $row['item'] . " ";
echo "" . date('F, D, Y',
srttotime($row['date'])) . "echo "" . $amount = $row['amount'] ";
== 0 ?'' : number_format($row['amount']) .
"
echo "
//use the data function to convert the db date format to a more presentable format
//d is for a two digit date, 01 to 31
//f is for the full text of the momnth, January, ect.
//y is the four digit year, 2018, ect. -->
//the second argument, strtotime() function converts date (yyy-mm-dd) to UNIX timestamp, which is a requirment of using the date function-->
$total += $row['amount']; //creating a sum
$CUST_ID++; //increment operator
}?>TOTAL