after I switched site to php 7 with code igniter frame work folowing code refuse to work .
can some one guide me please
<?php
$query="SELECT * FROM xxxxxxxxxxx ORDER BY cswdate ASC";$result=mysql_query($query);
$num=mysql_num_rows($result);
echo "
";
$i=0;while ($i < $num) {$NAME=mysql_result($result,$i,"NAME");
$PHONE=mysql_result($result,$i,"PHONE");
$DATE=mysql_result($result,$i,"DATE");
$feedbackI=mysql_result($result,$i,"ID");
$pms=mysql_result($result,$i,"pms");
echo "
| $feedbackI | $NAME | $PHONE |
$pms | $DATE |
";
$i++;}?>
PMS CASES Case working date
|
|---|
<?php
$query="SELECT * FROM users WHERE status != 'archived' AND caseNumber = 'CTW' OR status != 'archived' AND caseNumber = 'CTWN' ORDER BY next_visit_date ASC";$result=mysql_query($query);
$num=mysql_num_rows($result);
echo "
";
$i=0;while ($i < $num) {$patitName=mysql_result($result,$i,"firstname");
$cswdate=mysql_result($result,$i,"next_visit_date");
$feedbackI=mysql_result($result,$i,"id");
echo "
|
$patitName | $cswdate |
";
$i++;}?>
|
CASES WAITING FOR FOLLOWUP
|
|---|
<?php
$query="SELECT * FROM XXXXXX WHERE last_activity < next_visit_date AND status != 'archived' AND caseNumber != 'CTW' AND caseNumber != 'CTWN' ORDER BY next_visit_date ASC";$result=mysql_query($query);
mysql_close();
$num=mysql_num_rows($result);
echo "
";
$i=0;while ($i < $num) {$patitName=mysql_result($result,$i,"firstname");
$cswdate=mysql_result($result,$i,"next_visit_date");
$feedbackI=mysql_result($result,$i,"id");
$Caseno=mysql_result($result,$i,"caseNumber");
echo "
|
$patitName | $Caseno |
$cswdate |
";
$i++;}?>
|
