Re: bucle while for to msqyl
| From: | Serge Fonville | Date: | Sun, 16 Sep 2012 21:06:03 +0000 |
| Subject: | Re: bucle while for to msqyl | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-319097@lists.php.net to get a copy of this message | ||
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@gmail.com>
>
>
> 2012/9/16 El Ale... <alexissaucedo@gmail.com>
>
> 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@gmail.com>
>>
>>> 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@gmail.com>
>>>
>>> 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
>>>>
>>>
>>>
>>
>