query progress

[timus]

Hi all

I'm trying to import a large file into a database and give feedback to the user on how the import is going.

I maintain variables in a session or in a database to say how many records it has read from the file. But i can't show these values until the whole process has completed. I've tried running a seperate script in another window to query the session or the database on a timer (every 3 seconds) but it doesn't work till the file has completed its processing

Any suggestions would be great!

Thanks

Tim

[rbblue8]

So you are looking to view live data?

the database thing will work as long as you tell the php script to update the mysql databse every time the page is submitted.

is that what you looking for??

[timus]

Hi thanks for the reply.

Yes i'm looking to view the live data but the script that actually updates the database only gets submitted once and after reading 5 records from a file, it updates the database or the session with a value in a counter - nothing fancy. But the second script that is supposed to be viewing this counter doesn't read anything till first script has completed.

How do i tell the script to update the database and as you suggest?

Many thanks

Tim

Think I've solved it now by using mysql_unbuffered_query() to insert the records, does anyone have a better way of doing this? I'd be grateful for any suggestions