[PHP-DB] Subject: Struggling [Is : With database normalisation]

2004-05-05 Thread Neil Smith [MVP, Digital media]
Probably something as simple as changing the structure to a more normalised form would help : By adding a table which links evt_details to evt_sponsors, you do away with the need to have (up to 4) distinct fields to hold the evt_sponsor in your evt_details table. So add something like table :

Re: [PHP-DB] Problem with PHP & ODBC

2004-05-05 Thread Robert Twitty
> > If you are able to place the Access database on a Windows machine that can > > be accessed by the Linux machine, then you can use odbtp. You can get it > > at http://odbtp.sourceforge.net. > > > > -- bob > > My problem is i can't modify my PHP code. Actually the web site runs on a > windows200

php-db@lists.php.net

2004-05-05 Thread 高会娟
Hi, I found a big problem of mssql dll. I have 2 servers A(WinXP Pro_CN) and B(Win2000 Pro_CN).I am in China. IIS(Configed PHP) are on both servers. SQL Server are on server A. Just use mssql_connect($host,$user,$pass)to connect to the SQL Server. After I installed the WindowsXP-K

Re: [PHP-DB] Problem with PHP & ODBC

2004-05-05 Thread ofontes
> > I try to configure a web server under Debian/GNU/Linux Sarge. All > fonctionning > > perfectly except odbc connect. > > > > I have to read datas in an ACCESS2000 mdb file to import in Mysql. > > > > Actually this run correct under a windows 2000 workstation with > apache/PHP/Mysql > > > > > > I

Re: [PHP-DB] Struggling

2004-05-05 Thread Mark
--- Erik Meyer <[EMAIL PROTECTED]> wrote: > Hope someone can help me. > > I have two tables: > > evt_details > evt_sponsors > > The structure is as follows: > > evt_details evt_sponsors > > evt_detail_id (INT)(PK)

Re: [PHP-DB] Problem with PHP & ODBC

2004-05-05 Thread Robert Twitty
If you are able to place the Access database on a Windows machine that can be accessed by the Linux machine, then you can use odbtp. You can get it at http://odbtp.sourceforge.net. -- bob On Wed, 5 May 2004 [EMAIL PROTECTED] wrote: > Hi, > I try to configure a web server under Debian/GNU/Linux

RE: [PHP-DB] Losing MySQL connection with multiple database classes

2004-05-05 Thread Mika Porspakka
Oh damn. The class was missing the link identifier in one of the functions and that reset the rest of the class instances too. Thanks, probably would have taken hours before i had taken a look at the class.. Check your class... Maybe it resets the connection each time you create it. -Origi

RE: [PHP-DB] Losing MySQL connection with multiple database classes

2004-05-05 Thread Uzi Klein
Check your class... Maybe it resets the connection each time you create it. -Original Message- From: Mika Porspakka [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 12:23 To: [EMAIL PROTECTED] Subject: [PHP-DB] Losing MySQL connection with multiple database classes Hello all. I

[PHP-DB] Losing MySQL connection with multiple database classes

2004-05-05 Thread Mika Porspakka
Hello all. I'm getting a weird problem trying to use a database class for multiple connections for different databases on the same server. Whenever I make a new instance of the class, all the previously opened class instances connect to that new MySQL database. So, for example, if I have somet

[PHP-DB] Problem with PHP & ODBC

2004-05-05 Thread ofontes
Hi, I try to configure a web server under Debian/GNU/Linux Sarge. All fonctionning perfectly except odbc connect. I have to read datas in an ACCESS2000 mdb file to import in Mysql. Actually this run correct under a windows 2000 workstation with apache/PHP/Mysql I installed on my debian odbc too