Michael Stassen wrote:
Amer Neely wrote:
Both scripts, which reside in the same directory on the server, are
run through the web browser. And they do access the same database, and
the same tables.
So, same web server, same mysql server, same connection settings. Good.
Does phpmyadmin connect
Michael Stassen wrote:
Amer Neely wrote:
Both scripts, which reside in the same directory on the server, are
run through the web browser. And they do access the same database, and
the same tables.
So, same web server, same mysql server, same connection settings. Good.
Does phpmyadmin connect
Amer Neely wrote:
Both scripts, which reside in the same directory on the server, are run
through the web browser. And they do access the same database, and the
same tables.
So, same web server, same mysql server, same connection settings. Good.
Does phpmyadmin connect to mysql as the same user
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
On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote:
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
Brian Reichert wrote:
On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote:
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
Brian Reichert wrote:
On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote:
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
You can eliminate webserver/browser/caching issues from consideration by
trying your query directly in the mysql client.
Are you using InnoDB and transactions? It sounds to me as if you deleted
the record but have not yet committed. In that case, the deleted record
will be gone for the
Amer Neely wrote:
Brian Reichert wrote:
On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote:
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
Amer Neely wrote:
Amer Neely wrote:
Brian Reichert wrote:
On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote:
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
Michael Stassen wrote:
Amer Neely wrote:
Amer Neely wrote:
Brian Reichert wrote:
On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote:
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
Michael Stassen wrote:
Amer Neely wrote:
Amer Neely wrote:
Brian Reichert wrote:
On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote:
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
Amer Neely wrote:
snip
OK, obviously a bit more background seems to be in order.
My site is hosted but I am not the administrator. I have 2 perl scripts,
behaving as already described. I also have phpMyAdmin access to my
databases. I don't have command line access to the server.
Well, that's a
Amer Neely wrote:
snip
I'm pretty sure it's not. With a properly functioning mysql server,
you need neither FLUSH TABLES nor the RELOAD privilege to delete a row
from a table. See the manual for a description of FLUSH TABLES
http://dev.mysql.com/doc/mysql/en/FLUSH.html.
I did and imagine my
Michael Stassen wrote:
Amer Neely wrote:
snip
OK, obviously a bit more background seems to be in order.
My site is hosted but I am not the administrator. I have 2 perl
scripts, behaving as already described. I also have phpMyAdmin access
to my databases. I don't have command line access to the
15 matches
Mail list logo