Since the value is never changed inside the loop, it will run indefintely or stop immediately. You need to re-request the value from the database to change $numero to a possible other value. Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Microsoft! They need to add TRUNCATE PARTITION in SQL Server https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table 2012/9/16 El Ale... <alexissaucedo@xxxxxxxxx> > yes it 1 = 1 its (true) bucle's run, but! if 1 is not same 1 bucle break. > when consulted database and this value is 1, the loop continues, but when > changing the value of the database for example "value 2", the loop should > stop because 1 is not equal to 2 but not Doing so ignores it and segue > running as if the value is one, that's the problem > > Thank you! > > > 2012/9/16 Serge Fonville <serge.fonville@xxxxxxxxx> > >> Also, if $numero equals 1, it always prints 1. >> Is that the expected behaviour? >> >> When it does not match 1, it does nothing except it echos 1 twice, first >> in the conexion.php and second in the first iteration of the while loop >> >> Kind regards/met vriendelijke groet, >> >> Serge Fonville >> >> http://www.sergefonville.nl >> >> Convince Microsoft! >> They need to add TRUNCATE PARTITION in SQL Server >> >> https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table >> >> >> >> 2012/9/16 El Ale... <alexissaucedo@xxxxxxxxx> >> >>> >>> >>> 2012/9/16 El Ale... <alexissaucedo@xxxxxxxxx> >>> >>> Im sorry "reset;" is not, this is: >>>> >>>> <? >>>> include("conexion.php"); >>>> >>>> do { >>>> >>>> >>>> echo "$numero"; >>>> sleep(1); >>>> >>>> >>>> if ($numero == 1) >>>> >>>> continue; >>>> break; >>>> } while (true); >>>> >>>> ?> >>>> >>>> Thanks! >>>> >>>> >>>> 2012/9/16 Serge Fonville <serge.fonville@xxxxxxxxx> >>>> >>>>> Hi, >>>>> >>>>> if ($numero == 1) >>>>>> reset; >>>>>> continue; >>>>>> break; >>>>>> } while (true); >>>>> >>>>> >>>>> If the $numero is equal to 1 reset seems odd >>>>> reset is a function.and requires an array >>>>> Based on your code, this would run indefintely >>>>> Since there are no braces after the if statement, only the first >>>>> statement is executed when $numero equals 1 >>>>> >>>>> Also, is this your actual code? >>>>> >>>>> If not and possible please add that >>>>> >>>>> HTH >>>>> >>>>> Kind regards/met vriendelijke groet, >>>>> >>>>> Serge Fonville >>>>> >>>>> http://www.sergefonville.nl >>>>> >>>>> Convince Microsoft! >>>>> They need to add TRUNCATE PARTITION in SQL Server >>>>> >>>>> https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table >>>>> >>>>> >>>>> >>>>> 2012/9/16 El Ale... <alexissaucedo@xxxxxxxxx> >>>>> >>>>> hi! im new in this forum, i not speak very good english, apologise im >>>>>> spanish. >>>>>> I have a problem, need one infinit bucle to mysql only "true" if >>>>>> "false" >>>>>> break this, for example: >>>>>> >>>>>> prueba.php: >>>>>> >>>>>> <? >>>>>> include("conexion.php"); >>>>>> >>>>>> do { >>>>>> >>>>>> >>>>>> echo "$numero"; >>>>>> sleep(1); >>>>>> >>>>>> >>>>>> if ($numero == 1) >>>>>> reset; >>>>>> continue; >>>>>> break; >>>>>> } while (true); >>>>>> >>>>>> ?> >>>>>> >>>>>> ############################################################3 >>>>>> >>>>>> connect to mysql >>>>>> >>>>>> conexion.php: >>>>>> >>>>>> <? >>>>>> >>>>>> $conexion = mysql_connect("localhost", "alexis", "123456"); >>>>>> mysql_select_db("probando", $conexion); >>>>>> $queEmp = "SELECT n FROM numero WHERE n LIKE 1"; >>>>>> $resEmp = mysql_query($queEmp, $conexion) or die(mysql_error()); >>>>>> $totEmp = mysql_num_rows($resEmp); >>>>>> if ($totEmp> 0) { >>>>>> while ($rowEmp = mysql_fetch_assoc($resEmp)) { >>>>>> $numero = $rowEmp['n']; >>>>>> >>>>>> } >>>>>> echo "$numero"; >>>>>> } >>>>>> mysql_close($conexion); >>>>>> ?> >>>>>> >>>>>> What I do is to run the loop as long as the value "$ number" is equal >>>>>> to >>>>>> "1" in mysql I have a single field called "n" with the value "1" and >>>>>> runs, >>>>>> now the problem is the next, I run the loop with the value "1" in >>>>>> mysql and >>>>>> it runs fine but when I go to mysql and change the value to "2" (which >>>>>> would be an incorrect and should leave) the loop ignores him and >>>>>> continues >>>>>> running, I was reading a lot about the loops but I can not make it >>>>>> work in >>>>>> this way could you please give me a hand with this? or if I'm wrong >>>>>> What >>>>>> else I can do an infinite command if it fulfills a function and if >>>>>> they do >>>>>> not?. >>>>>> >>>>>> Best regards >>>>>> >>>>> >>>>> >>>> >>> >> >
