SQL查询返回有限的结果

问题描述：

Working with WordPress, running a custom query to pull all records relating to a specific condition. When I run the query in phpmyadmin it returns all records, when I run the query through PHP code, only 2-5 results return, need to find out how to resolve this:

// get variables from form page
$txtReg = $_REQUEST['txtReg'];
$txtMsg = $_REQUEST['txtMsg'];

// connect to database
$mydb = new 
wpdb('***','***','***','***');

// run the query to fetch all cell numbers from the region variable
$query = "SELECT * FROM tblusers WHERE `Region` ='$txtReg'";
$rows = $mydb->get_results($query);

// display all cell numbers from that region
foreach ($rows as $row) {
  $txtCell = $row->Cell;
  //doSendSMS($txtCell,$txtMsg);
  echo $txtCell;  
}

E.g there are 100 cell numbers in Region A, only a few are returned and echoed, not all 100 like it should be, so when I run the sms code (which is the actual function, echo is used just to test results), not all receive the sms.

答

@Caius Jard was correct about the settings in the database, it was in fact limited even though no limit clause was applied in the sql query itself. The code is functional in my setup but was limited by the default settings.

tested using:
$query = "SELECT * FROM tblusers WHERE Region ='$txtReg' LIMIT 100";

SQL查询返回有限的结果

相关推荐