I have a database with a table which includes among others, one column of dates (the column is titled 'date') in the format of Y-m-d.
I want to extract all the rows of data which have been logged during the current month, so I am using the following query:
$year_month = date("Y-m");
$query = "SELECT date FROM tracker WHERE date LIKE '$year_month%'";
When I execute the query and attempt to output it visually, I get the error "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource on line 64".
Line 64 is the beginning of the following loop:
while($row = mysql_fetch_array($result, MYSQL_ASSOC)
{
echo "Name :{$row['date']} <br>";
}
I've scoured google and had a look here too, but I can't seem to figure out this seemingly simple problem. As far as I can tell, the actual query is executing just fine.
Any ideas?
** Additional - Call to MySQL Query Below **
$result = mysqli_query($conn, $query);
$conn refers to the following line:
$conn = @mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or die ('Error connecting to MySQL');