>
> If you wrap the query inside your while loop at the point where you want
> to check for a change of the value it will change at every iteration.
For ease of use, it would be better to create a function around the data
gathering part, i.e.
> function updateNumero() {
> $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'];
> }
> }
> return $numero;
> }
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>
> 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
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
