RE: [PHP-DB] MySQL Connect using Dreamweaver

2005-10-13 Thread Matthias Willerich
That's a very common one. You're on windows, right? Try putting in consider upgrading MySQL client into google. The first one I found was this one: http://www.experts-exchange.com/Web/Web_Languages/PHP/PHP_Windows/Q_21252231 .html Although the guy first claims it's not the OLD_PASSWORD problem,

[PHP-DB] Defined Constants

2005-10-13 Thread Ng Hwee Hwee
Hi all, just a very simple question. my form has the following define statements and select box: 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

RE: [PHP-DB] Defined Constants

2005-10-13 Thread Matthias Willerich
2 possibilities: either you put the defined value instead of the definition down in the option value (but i'm sure you thought of this one) or you use echo constant($_POST['myType']);. Or GET, depending on how you send your form. Hey, this time I learned something, too! I found it in the php

[PHP-DB] Re: MySQL Connect using Dreamweaver

2005-10-13 Thread Blaz
Hi. You must use mysqli which is only supported in php5. Of corse if you will use MySQL5. regards W Roothman wrote: Dear All, I have installed MySQL 5 with PHP 4.3.3. When trying to connect to a database form the 'Database' tab in Dreamweaver, I now get the following error when trying to

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: select name=myType option value=JOVIAL?=JOVIAL;?/option option value=CHEERFUL?=CHEERFUL;?/option option

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

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 everyday); select

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 php-db@lists.php.net Sent: Thursday, October 13, 2005 2:28 PM Subject: RE: [PHP-DB] Defined Constants 2 possibilities: either

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

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:

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