1 database; 2 scripts; different results

[Amer Neely]

I have one database that is currently being accessed by 2 scripts which query the database. One is 
for me to administer the db contents. The other is for public display, and so has the final buttons 
 disabled for 'Delete', 'Add', 'Modify', 'Dump', and 'Restore'. Users can go through the motions of 
each feature to see how things look, but the buttons to commit the action are disabled. Both scripts 
access the same tables in the database.

My question is, in my admin script I deleted a record, but it still shows up using the other script. 
 The admin script shows 102 records and the other shows 103. The record does show up in the 
'public' script, so it's not just a mis-count. How is this possible? Is there a step I'm missing 
because I'm using 2 different scripts to access the same tables? That doesn't make sense. Can 
someone shed some light on what might be happening here?

MySQL 4.0.20a for Win32
--
/* All outgoing email scanned by AVG Antivirus */
Amer Neely, Softouch Information Services
Home of Spam Catcher & North Bay Information Technology Networking Group
W: www.softouch.on.ca
E: [EMAIL PROTECTED]
Perl | PHP | MySQL | CGI programming for all data entry forms.
"We make web sites work!"
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]