Re: bucle while for to msqyl

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
>>>>
>>>
>>>
>>
>

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux