Counting rows Mysqli

[cobusbo]

Hi I'm using php file to retrieve the amount of records in my database, but all of a sudden I get 0 results. It worked fine a few days ago. I got PHP 5.2.* on my host. Here is the current script that I use.

Did I made a mistake somewhere?

<?php
$con=mysqli_connect("******","*****","*****","****");

// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$sql="SELECT * FROM mxit";

if ($result=mysqli_query($con,$sql))
  {
 

$rowcount=mysqli_num_rows($result);
  //printf("Result set has %d rows.\n",$rowcount);

    
  // Free result set
  mysqli_free_result($result);
}

mysqli_close($con);
?>

[QuickOldCar]

other than you had it commented out and no db credentials, looks ok

<?php
$con=mysqli_connect("******","*****","*****","****");
// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql="SELECT * FROM mxit";
if ($result=mysqli_query($con,$sql))
  {
$rowcount=mysqli_num_rows($result);
  echo "Result set has $rowcount rows. <br />"; //because I like this way better
  
  // Free result set
  mysqli_free_result($result);
}
mysqli_close($con);
?>

[cobusbo]

I'm still getting the result "Result set has 0 rows." but I got 277 rows in my database...

[QuickOldCar]

odd issue, you sure have correct database and mxit is the table with the 277?

[Barand]

If all you want is a row count then selecting all the records and counting them is the inefficient way to do it. You should use

 

SELECT COUNT(*) as count FROM mxit

 

Then look at value returned in $row['count']