[PHP-DB] php/mysql error

2004-07-27 Thread redhat
I am getting a weird error on one of my servers that says something about query requires full tablescan. I was not getting this error until today that I noticed. I Googled for a minute and saw where a ton of other sites had the same problem but no reason why. I did find one board that said to

[PHP-DB] dbx_connect() forcing a new connection to mysql

2004-07-27 Thread J.T. Moore
Is there a way to force dbx_connect() to create a new connection to a mysql database? The reason I ask is that I want to be able to use transactions with mysql Innodb tables, but from the notes in the php mysql function documentation, it appears that if two php scripts begin a transaction over

[PHP-DB] Re: php/mysql error

2004-07-27 Thread David Robley
On Wed, 28 Jul 2004 02:36, Redhat wrote: I am getting a weird error on one of my servers that says something about query requires full tablescan. I was not getting this error until today that I noticed. I Googled for a minute and saw where a ton of other sites had the same problem but no

[PHP-DB] Session Values Change

2004-07-27 Thread Jacob Hackamack
Hello, I am trying to start a blog page where the person selects their person they want to view (bottom of the page) and then it somehow changes the session variable (top of the code) and then accesses the database. I was wondering, what is the correct way to do something like this. I have

[PHP-DB] JOIN question

2004-07-27 Thread Chris Payne
Hi there everyone, I'm transferring a client's product from a Visual Basic .NET ACCESS 2000 application to run on a custom install of Apache/MySQL/PHP which I created (With a custom installer which sets everything up for them). My question though, is on looking through their ACCESS