title: request in mysql send no data, except in phpmyadmin
body: <p>I met some trouble while creating a podium.</p>
  
  <p>In fact I would like to display the best of my employee.</p>
  
  <p>SO i have done a podium</p>
  
  <p>and for the first three best, I do some query like that:</p>
  
  <p>for the first one:</p>
  
  <pre><code>$sql="SELECT `gestionnaire`.`nom`,`gestionnaire`.`prenom`,`gestionnaire`.`urlavatar`,`gestionnaire`.`civilite`, `versements`.`date_reception`, `versements`.`etat`, SUM(honoraires) as TOTAL FROM `versements` INNER JOIN `gestionnaire` ON `gestionnaire`.`id` = `versements`.`gestionnaire_id` WHERE `versements`.`id_company` ='".$societe['id']."' AND `versements`.`etat`='3' AND`date_reception` &gt; '".date('Y-m-')."01' AND `date_reception` &lt; '".date('Y-m-')."31' GROUP BY `versements`.`gestionnaire_id` ORDER BY `versements`.`honoraires` DESC LIMIT 0,1";
  </code></pre>
  
  <p>For the second one:</p>
  
  <pre><code>$sql2="SELECT `gestionnaire`.`nom`,`gestionnaire`.`prenom`,`gestionnaire`.`urlavatar`,`gestionnaire`.`civilite`, `versements`.`date_reception`, `versements`.`etat`, SUM(honoraires) as TOTAL FROM `versements` INNER JOIN `gestionnaire` ON `gestionnaire`.`id` = `versements`.`gestionnaire_id` WHERE `versements`.`id_company` ='".$societe['id']."' AND `versements`.`etat`='3' AND `date_reception` &gt; '".date('Y-m-')."01' AND `date_reception` &lt; '".date('Y-m-')."31' GROUP BY `versements`.`gestionnaire_id` ORDER BY `versements`.`honoraires` DESC LIMIT 1,2";
  </code></pre>
  
  <p>And for the third:</p>
  
  <pre><code>$sql3="SELECT `gestionnaire`.`nom`,`gestionnaire`.`prenom`,`gestionnaire`.`urlavatar`,`gestionnaire`.`civilite`, `versements`.`date_reception`, `versements`.`etat`, SUM(honoraires) as TOTAL FROM `versements` INNER JOIN `gestionnaire` ON `gestionnaire`.`id` = `versements`.`gestionnaire_id` WHERE `versements`.`id_company` ='".$societe['id']."' AND `versements`.`etat`='3' AND `date_reception` &gt; '".date('Y-m-d',strtotime($_POST['date_debut']))."' AND `date_reception` &lt; '".date('Y-m-d',strtotime($_POST['date_fin']))."' GROUP BY `versements`.`gestionnaire_id` ORDER BY `versements`.`honoraires` DESC LIMIT 2,3";
  </code></pre>
  
  <p>For the three best I have no trouble.</p>
  
  <p>But when I try to display the rest, from the 4th to the end, I met some trouble, Actualy I've done a query that I limit 4,100 to display the rest.</p>
  
  <p>So the query is like that:</p>
  
  <pre><code>$rqt="SELECT `gestionnaire`.`nom`,`gestionnaire`.`prenom`,`gestionnaire`.`urlavatar`,`gestionnaire`.`civilite`, `versements`.`date_reception`, `versements`.`etat`, SUM(honoraires) as TOTAL FROM `versements` INNER JOIN `gestionnaire` ON `gestionnaire`.`id` = `versements`.`gestionnaire_id` WHERE `versements`.`id_company` ='".$societe['id']."' AND `versements`.`etat`='3' AND `date_reception` &gt; '".date('Y-m-d',strtotime($_POST['date_debut']))."' AND `date_reception` &lt; '".date('Y-m-d',strtotime($_POST['date_fin']))."' GROUP BY `versements`.`gestionnaire_id` ORDER BY `versements`.`honoraires` DESC LIMIT 3,100";
  </code></pre>
  
  <p>when I copy and paste the echo of the query in phpmyadmin it works fine, it display to me the good results.</p>
  
  <p>But when I try to echo the result, I have nothing.</p>
  
  <p>I've done a loop that echo the results like that:</p>
  
  <pre><code>&lt;p align="left"&gt;&lt;?php
  if(!isset($_POST['date_debut'])) { $rqt="SELECT `gestionnaire`.`nom`,`gestionnaire`.`prenom`,`gestionnaire`.`urlavatar`,`gestionnaire`.`civilite`, `versements`.`date_reception`, `versements`.`etat`, SUM(honoraires) as TOTAL FROM `versements` INNER JOIN `gestionnaire` ON `gestionnaire`.`id` = `versements`.`gestionnaire_id` WHERE `versements`.`id_company` ='".$societe['id']."' AND `versements`.`etat`='3' AND `date_reception` &gt; '".date('Y-m-')."01' AND `date_reception` &lt; '".date('Y-m-')."31' GROUP BY `versements`.`gestionnaire_id` ORDER BY `versements`.`honoraires` DESC ";
  }
  else
  {
      $rqt="SELECT `gestionnaire`.`nom`,`gestionnaire`.`prenom`,`gestionnaire`.`urlavatar`,`gestionnaire`.`civilite`, `versements`.`date_reception`, `versements`.`etat`, SUM(honoraires) as TOTAL FROM `versements` INNER JOIN `gestionnaire` ON `gestionnaire`.`id` = `versements`.`gestionnaire_id` WHERE `versements`.`id_company` ='".$societe['id']."' AND `versements`.`etat`='3' AND `date_reception` &gt; '".date('Y-m-d',strtotime($_POST['date_debut']))."' AND `date_reception` &lt; '".date('Y-m-d',strtotime($_POST['date_fin']))."' GROUP BY `versements`.`gestionnaire_id` ORDER BY `versements`.`honoraires` DESC LIMIT 3,100";
  }
  
  $res=mysql_query($rqt);
  $i5=3;
  while($donnees=mysql_fetch_assoc($res));
  {
  echo $rqt;  
  ?&gt;
  Position &lt;?php echo ++$i5 ; var_dump($donnees); ?&gt;: &lt;?php echo $donnees['civilite'].' '.$donnees['nom'].' '.$donnees['prenom'] ; ?&gt; Total d'honoraires: &lt;?php  echo number_format($donnees['TOTAL'], 2, ',', ' ');?&gt; &amp;euro;&lt;br /&gt;&lt;?php }?&gt;&lt;/p&gt;
  </code></pre>
  
  <p>The display of the result display nothing when I do a var_dump it says bolean false.</p>
  
  <p>I'm realy lost, I do not understand why in phpmyadmibn the request send to me some results, and there in my page I have this kind of mistake.</p>
  
  <p>Anykind of help will be much appreciated.</p>
  
  <p>Kind regards.</p>
  
  <p>SP.</p>