Having no experience of PHP and having created all my PHP pages with very grateful help from others on here, I have had limited success in converting things but am struggling with some of the SQL queries.
Anything that uses mysql_result in particular is causing me issues as I don't understand how to run it in mysqli, assuming at first that it would be mysqli_result, but it seems not.
So, if this was my query, what would I do to change it to run with mysqli :
Code: Select all
.....$resulttysmtotrain=mysql_result(mysql_query("SELECT SUM(TotRainFall) FROM Afile WHERE (YEAR(LogDate)=YEAR(NOW()) AND (MONTH(LogDate)=$mo))"),0);?>