Re: bucle while for to msqyl

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

 



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