[SOLVED] while loop problem..

[zgkhoo]

function detect(){
$counter=0;
echo "</br>detect";
$result=mysql_query("SELECT * FROM result") or die('Query failed: ' . mysql_error());

while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
    echo "</br>counter=$counter";
    

echo "</br>$row[Category]";
echo "</br>Drawdate in sql=$row[DrawDate]";
echo "</br>POST drawdate=$_POST[drawnumber]";	

if ($row[Category]=='Magnum'&& $row[DrawDate]==$_POST[drawnumber]) {

	echo "if";
	return 1;



}//end if
   

		else{
			echo "else";
		 return 0;

		}



$counter++;
}//end while	


}//end detect()

 

it just will detect one first record of the mysql database.

y?

it just appear

 

detect
counter=0
SgPools
Drawdate in sql=2007-07-09
POST drawdate=2007-08-08else0

 

after i remove the if else statement then it can successfully display all 5 record.

anyone know y?

 

 

[kenrbnsn]

You have a "return" statement in you're "if". This ends the loop.

 

Please spell out all your words ...

 

Ken

[zgkhoo]

"return" keyword end the loop?

why not "break" end the loop?

others programming language also like that?

??? ???

 

 

[sasa]

"return" keyword end the function

[haaglin]

break; ends the current loop

 

EDIT:

 

Haha.. meant continue.. sorry..

[kenrbnsn]

You want to use the continue statement.

 

Ken

[zgkhoo]

return 0; return 1; end the function

how abt return $found; ?

[MmmVomit]

Is this what you're trying to do?

 

<?php

function detect()
{
  $counter=0;
  echo "</br>detect";
  $result=mysql_query("SELECT * FROM result") or die('Query failed: ' . mysql_error());

  while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) 
  {
    echo "</br>counter=$counter";
    echo "</br>$row[Category]";
    echo "</br>Drawdate in sql=$row[DrawDate]";
    echo "</br>POST drawdate=$_POST[drawnumber]";	

    if ($row[Category]=='Magnum'&& $row[DrawDate]==$_POST[drawnumber]) 
    {
      echo "if";
      // return 1;
    }//end if
    else
    {
      echo "else";
      continue;
      // return 0;
    }
    $counter++;
  }//end while

  return $counter;	
}//end detect()
?>

[zgkhoo]

function detect(){
$counter=0;
$found=0;
echo "</br>detect";
$result=mysql_query("SELECT * FROM result") or die('Query failed: ' . mysql_error());

while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
    echo "</br>counter=$counter";
    

echo "</br>$row[Category]";
echo "</br>Drawdate in sql=$row[DrawDate]";
echo "</br>POST drawdate=$_POST[drawnumber]";	

if ($row[Category]=='SgPools'&& $row[DrawDate]==$_POST[drawnumber]) {

	echo "if";
        $found=1;




}//end if
   

		else{
			echo "else";


		}



$counter++;
}//end while	
return $found;


}//end detect()

 

solved..thanks..