runs in the background

[1zeus1]

Or need a page " nome.php" runs in the background
every 2 seconds.
Without:
header ("Refresh: 2, url =". $ _SERVER ["PHP_SELF"]);
or
cron
...............................
page name.php

$con = mysql_connect("localhost","xxxxx","xxxxx");
if (!$con){die('Could not connect: ' . mysql_error());}
mysql_select_db("xxxx", $con);
$result = mysql_query("SELECT * FROM bbb ");
$row_ro = mysql_fetch_array($result);
$id_2 = $row_ro['id_2'];
$query0 = "UPDATE bbb.siti SETtop_2 = '2' WHERE bbb.id_2 ='$id_2'";
mysql_query($query0);
mysql_close($con);
.....................

.........................

thank you very much to all

[bradgrafelman]

In the background of... what?

[1zeus1]

On server
Cron is activated every minute, I need every 2 second

[Weedpacket]

For one thing, why do you even need to use PHP for this? You could just use MySQL's own client to send the update command.

You can start PHP as a background process in the same way as any other; set its timeout so that it doesn't time out, and have it [man]sleep[/man] for two seconds between updates.

But mainly I'm wondering what the use case for this is: I don't see anything happening here that should need to run every two seconds. Even if there is a need to (basically) copy some information from one column to another, can it not wait until something actually queries the table for it? Or, alternatively, when the information is inserted?

[bpat1434]

It looks to me like MySQL replication of some sort which begs the question why not use native MySQL replication?

[sneakyimp]

This script will do something every two seconds until you forcibly kill it:

function do_something() {
  // put your code in here
}

while TRUE {
  do_something();
  sleep(2);
}

You can launch it in the background from a command line like so:

php script.php &