RE: [PHP-DB] continuously view database updates.

2001-03-26 Thread Rubanowicz, Lisa

HI Kevin,
you are the first Irish person I have seen on this list!!
Anyhow, When you submit the form insure that the form submits to itself so
you don't have to worry about a refresh. On the top of the page have the
form and below do the select statement to show what is in the table. When
the form is submitted to itself it will run the select statement again and
show the latest data.

Here is some code for a complete page that can be seen at
http://www.navanwebdesign.com/php/admin/index.php
Please feel free to mess around with it.  I am a beginner too so to get a
file that does all can be so helpful.  However because I am a beginner this
may not be the most effective way of doing it.
All the Best
Lisa


", $pg_desc) . "','$pg_img_url','$pg_price')"; 

$result2 = mysql_query($sql2); 
}


?>




if (navigator.appName == "Netscape") {
StyleSheet = "netstyle.css"
} else {
StyleSheet = "iestyle.css"
}

document.write('<link rel=stylesheet type="text/css" href="'
+StyleSheet + '">')

Add a Message


if (navigator.appName == "Netscape") {
StyleSheet = "netstyle.css"
} else {
StyleSheet = "iestyle.css"
}

document.write('<link rel=stylesheet type="text/css" href="'
+StyleSheet + '">')


 
 
 

 


Add a New Web Page

Auction Page Name


Auction Title


Auction Date



Catologue Number


Catalog Entry Description


Catalog Entry Image URL


Catalog Entry Price








Edit Web Page


Edit Auction Page
Edit page Title
Delete page Title

 
  
 
  
  
  " TARGET="bottom"> -
Show All listing for that 1 page
  &edit=yes" TARGET="bottom">EDIT
  &delete=yes">DELETE
  
  
  
  
  
  
  
  


-Original Message-
From: Kevin Connolly [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 3:44 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] continuously view database updates.


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.



Re: [PHP-DB] continuously view database updates.

2001-03-26 Thread Andreas D. Landmark

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]




[PHP-DB] continuously view database updates.

2001-03-26 Thread Kevin Connolly

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.