Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread Isaak Malik
Because then the connection resource isn't stored in the $link variable and you will be able to use the mysql functions without passing that variable to each function. On Wed, Jun 18, 2008 at 1:51 AM, Chris <[EMAIL PROTECTED]> wrote: > > > It means that either your mysql conenction details are no

[PHP-DB] Re: PHP-MySQL connection for particular module

2008-06-18 Thread Isaak Malik
You're very welcome, I understand that you need a solution which allows you to keep using the connection this way. I doubt that your php.ini is the cause so I'll suggest the following: Try executing your MySQL queries by passing the $link variable to the function as the connection resource: mysq

[PHP-DB] MSSQL and ODBC Connections with PHP on Windows

2008-06-18 Thread Wei, Alice J.
Hi, I am a newbie using the combination of PHP and MSSQL together. Can anyone tell me which method it might be better as far as using PHP on Windows with MSSQL database on a single machine? (The PHP and MSSQL database are not set up remotely on two different servers. I have set up bot

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread bateivan
Thank you, Chris, I tried your suggestion using regular connection. Unfortunately, I got the same result. See my reply to Isaak,s reply where I am going to post portion of my code to visualize what I am talking about. Thanx again chris smith-9 wrote: > > >> It means that either your mysql co

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread bateivan
Hello, To answer these qwestions: 1. I am using "include" in my code. 2. About the "$link = mysql_connect('localhost', 'root', 'testing');" variable. I can just include this line before mysql_query function and it works even without entering into mysql_query the "$link" variable. (Like the connec

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread Evert Lammerts
Pastebin works lots better when you're posting code: www.pastebin.com I don't see your database.php included in both of these modules. Where do you include it? EVert On Wed, Jun 18, 2008 at 9:38 PM, bateivan <[EMAIL PROTECTED]> wrote: > > Hello, > > To answer these qwestions: > 1. I am using "in

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread Isaak Malik
To Evert: 4. I am posting some of my code to compare. Module "carmade.php" works v.s. "login.php" which does not. Also, I am posting my "database.php" which is establishing the connection and is included in every page through "layout.php"->"common.php"->"database.php". To bateivan: I can only gu

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread Chris
Isaak Malik wrote: > Because then the connection resource isn't stored in the $link variable > and you will be able to use the mysql functions without passing that > variable to each function. RTM again. The link parameter is completely optional. If you don't specify it, it uses the last connect