How could I?, should use another command? I need to do that if the value of the script is the same as the database and repeat but stops. greetings! 2012/9/16 Serge Fonville <serge.fonville@xxxxxxxxx> > 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 >>>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> >
