RE: [PHP-DB] Defined Constants

2005-10-13 Thread Arno Kuhl
In your select, you need to remove the quotes around your defines, otherwise it is interpreted as a quoted string. So your select statement should look like: Arno DotContent Professional Content Management Solutions www.dotcontent.net -Original Mes

Re: [PHP-DB] Re: MySQL Connect using Dreamweaver

2005-10-13 Thread Sascha Kaufmann
You have to change the password hash to the old 3.23.x format if you don't want or can't use mysqli. Open a mysql shell and type something like: use mysql; UPDATE user SET password = OLD_PASSWORD('yourpass') WHERE user = 'youruser' AND host = 'localhost'; On Thu, 2005-10-13 at 08:23 +0200, Blaz w

RE: [PHP-DB] Defined Constants

2005-10-13 Thread Arno Kuhl
Oops - sorry, got that one completely wrong! A solution should say: form code: define("JOVIAL", "likes to joke alot"); define("CHEERFUL", "always wears a smile on his face"); define("ADVENTUROUS", "likes sports and plays well too"); define("MYSTERIOUS", "there's always something to discover everyd

Re: [PHP-DB] Defined Constants

2005-10-13 Thread Ng Hwee Hwee
this works like a charm!!! thanks alot!!! :o) - Original Message - From: "Matthias Willerich" <[EMAIL PROTECTED]> To: "Ng Hwee Hwee" <[EMAIL PROTECTED]>; "PHP DB List" Sent: Thursday, October 13, 2005 2:28 PM Subject: RE: [PHP-DB] Defined Constants > 2 possibilities: > either you put t

RE: [PHP-DB] MySQL Connect using Dreamweaver

2005-10-13 Thread Bastien Koert
try downloading the mysqli library (perhaps by grabbing all of version 5) and copying that into the extension folder for your 4.3.3 install of PHP...add the below line to the ini file : extension=php_mysqli.dll bastien From: "W Roothman" <[EMAIL PROTECTED]> Reply-To: "W Roothman" <[EMAIL PR

Re: [PHP-DB] Re: MySQL Connect using Dreamweaver

2005-10-13 Thread Sascha Kaufmann
Will, is mysql installed on your local machine or on a different server? Do you work with root or with a newly created user? If mysql is not installed on your local machine, you have to grant access from other machines to your database. Here's an example (with a newly created user). Example:

Re: [PHP-DB] Re: MySQL Connect using Dreamweaver

2005-10-13 Thread skaufmann
Will, is mysql installed on your local machine or on a different server? Do you work with root or with a newly created user? If mysql is not installed on your local machine, you have to grant access from other machines to your database. Here's an example (with a newly created user). Example: your

Re: [PHP-DB] Re: MySQL Connect using Dreamweaver

2005-10-13 Thread Shahmat Dahlan
Correct me if I'm wrong, but if I'm not mistaken Mysql 5 will not work in Dreamweaver. It will only work if you have 4.x (can't remember the exact version) Even if you have installed Mysql 4.x, u must make sure you add in old_password at the last line of the my.cnf If not, you can always updat