At 26.03.2001 15:44, you wrote:
>Hi,
>I am doing a college project which involves using PHP scripts to update a
>MySQL database. For demonstration purposes I would like the new updated
>table in my Database to be shown each time it is updates without me having
>to go to the command prompt window and type in select * from members; for
>example! I will have the command window open for the demo.
>Thanks
>Kev.
Live display of a mysql table isn't possible AFAIK, but you could fake it
through
scripting og programming on your preferred platform, just do a select *
from somewhere
statement every second (<- put favorite interval there) and display it the
way you
like it to be displayed...
PHP could do it, perhaps not the most effective solution, but certainly an easy
solution... use a persistant connection and HTTP-REFRESH or something, unless
you're dumping heavy work on the DB this should be fine, if we're talking
high-performance
time-critical and or high-load stuff here, you might wanna look at
somethingelse...
--
Andreas D. Landmark / noXtension
PGP ID:0xB2BEAE80 / 4096bits
Fingerprint:654B 3BCD 1130 9B3A 08BB AB1A BF72 841D B2BE AE80
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]