Count of fields code works in one server and does not work in another server

Asked Jun 25 '17 at 16:36

Active Jun 25 '17 at 17:57

Viewed 28 times

I am trying to select fields with a condition and display their counts. The counts display in one server while the same code does not display ANY counts ($num01 and $rowno)in another server. Both servers have same PHP version (5.6) and same database structure. Please guide.

Following is my code -

$con=mysqli_connect($host,$user,$password,$dbname);
$sql="select num, ode_y from Topics order by num asc";

$result = mysqli_query($con,$sql);

$sql1="SELECT * from Topics ORDER BY num ASC";
$result1=mysqli_query($con,$sql1);
$rowno = mysqli_num_rows($result1);

<span>Total $rowno registered 
topics</span>

while($row = mysqli_fetch_array($result))
{ 
    $odey1= ($row['ode_y']);

    $sql01="SELECT ode  
            from fltr2 AS s 
                INNER JOIN Register AS r ON s.sender=r.sender 
                            and r.reg=0 
                            and s.ode='$odey1'";

    $result01 = mysqli_query($con,$sql01);
    $num01=mysqli_num_rows($result01);

 <div>Counts : ".$num01."</a>
 </div>
}

edited Jun 25 '17 at 17:57

asked Jun 25 '17 at 16:36

user20152015

The display count is different because the numbers of rows in the tables on the different servers/databases are different and/or the row values are different. – Progman Jun 25 '17 at 17:00
In the second server, it does not display any counts at all – user20152015 Jun 25 '17 at 17:54
Please check the display of error messages, see https://stackoverflow.com/questions/1053424/how-do-i-get-php-errors-to-display?rq=1 – Progman Jun 25 '17 at 17:58
Checked. No error messages – user20152015 Jun 25 '17 at 18:23
Then check https://stackoverflow.com/questions/1475297/phps-white-screen-of-death why nothing is displayed at all. – Progman Jun 25 '17 at 18:28
@Progman This does not solve problem – user20152015 Jun 26 '17 at 06:10

Count of fields code works in one server and does not work in another server

0 Answers0