help needed with MySQL to MySQLi code snippet conversion
Hi, All. I have a code snippet in need of conversion for MySQLi.
I've used the following code (probably derived from an old forum post) to present a list of blog month + year archive links. After updating to PHP 7 this code causes the error "UNCAUGHT_EXCEPTION: Call to undefined function mysql_query()".
$query = "SELECT DATE_FORMAT(pubDate, '%M %Y') as dateAndYear, YEAR(pubDate) as year, MONTH(pubDate) as month FROM cmsb_blog GROUP BY dateAndYear ORDER BY pubDate DESC";
$result = mysql_query($query) or die("MySQL Error: ". htmlspecialchars(mysql_error()) . "\n");
while ($record = mysql_fetch_assoc($result)):
Simply changing mysql to mysqli isn't enough. I think it needs some further editing and am wondering if anyone here could offer assistance?