Re: bucle while for to msqyl

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

 



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

[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