Hi,
I'm moving from a host that has php version 4.3.11 to one that has version 4.4.2 - when transferring the site over including the database, most things seem to be working fine, however I've come across a bump in the road, here is the part of the script that doesn't seem to be working:
$hindsightquery = "SELECT DISTINCT LEFT(BlogDate,6) AS hindsightitems FROM tblBlog ORDER BY hindsightitems DESC";
$hindsightresult = mysql_query($hindsightquery);
$hindsightitem = mysql_fetch_array($hindsightresult); //get rid of first row
while($hindsightitem = mysql_fetch_array($hindsightresult))
{
$hindsightmonthnum = substr($hindsightitem['hindsightitems'],4,2);
$hindsightyearnum = substr($hindsightitem['hindsightitems'],0,4);
$hindsightlinktxt = date("F,Y",strtotime($hindsightyearnum."-".$hindsightmonthnum."-01"));
// rest of while function - just echoing variables and html..
I'm not sure what it is that seems to be not working on the new version of php, any help would be appreciated. Thanks.
PS: I've just checked and see that the data functions on other pages don't seem to be working properly either.. :/