Same Query every second, not once.

[nightkarnation]

Hey Guys,

I need some help and/or suggestions on how to apply the following:

 

Simple Example Code:

 

$result = mysql_query("SELECT Last_B_Time FROM MAIN WHERE Id = '$id'"); 
    $cant = 0; 
    while($row=mysql_fetch_array($result))
{ 		
	echo "Last_B_Time$cant=$row[Last_B_Time]&"; 
        $cant++;
    } 

 

I want this simple code/query and echo to be executed every second (not once), directly when test.php is opened.

What is the best way to do this? Using a timer?

 

Thanks a lot in advance!

 

 

[freelance84]

You want this script to run once a second when the page is loaded? Why?

[AyKay47]

I am not sure why you would want to do this, and your memory/server won't be thanking you...

 

[nightkarnation]

I have a dedicated server.

 

I need to do this, to retrieve the server date every second.

I know this would be easily fixed performing a calculation with just retrieving once the server date but I also need to know each second if there has been a new bid for any auction (its an auction site)

 

Any suggestions?

Thanks a lot!

[AyKay47]

i assume that when someone bids for an item, a form will be submitted which will trigger code...right?

So wouldn't you be "notified" then?

[nightkarnation]

The thing is that I need to do some automatic special features on different seconds...and I need to retrieve every single second in order to send these special features (from an outside application running every second through php).

[freelance84]

Well, the php script will only run (i think) with action from an outside source.

 

If you are wanting to send once a second a bit of data from the client to the server and back to the client... AJAX?

 

But then what if the connection slows at any point and the data transfer is 3 seconds? That would screw your script up.

 

What are the special functions? Do they need to be done by the server? Would a js function suffice?