PichelM

I\'m responding to the last entry in this thread re the Wellington / Thomson book. This book is the best I have come across and I can only recommend it to everyone starting to pick up PHP but have some programming knowledge already. There are most likely books that go into more depth, but the real strength of the book are the business scenarios it covers in the 2nd part of this book. Taken your objectives with the T-Shirt designs into account, it sounds as if this book could be the business for you. regards, PM

Yes, I\'ll second that. I do use DW as my main editor and PHP development tool. Main drawback is the missing layout view. I usually develop my data entry forms in \'normal\' HTML mode first and then copy/paste it into the PHP section once I\'m happy with formatting and the way how the Style Sheets are picked up. I use a local installation of an Apache as the testing server which makes quick tests and publishs out of DW really easy. PM

I personally prefer hand coding, too. But it really depends what environments etc you are used to. if you don\'t like using things like notepad then I\'d recommend Zend or DW to do the coding, as they take over a lot of things for you (formatting, colouring etc.). It\'s down to you really. P

Hi there, not a big problem really. If you managed to successfully get the mySQL database and the PHP running on your box then all you have to do in DW MX is to connect to the database server using the guides in your help views (if you can\'t see them, check in Properties that they are visible). You can see that the connect to the db is working if you see the dictionary definitions from your database in DW.

Hi there, Yes, you need Server Side scripting enabled when you set up your site in DW. So if you curently have it disabled, either change the existing site or create a duplicate one and copy your existing HTML sources across (they will still work). As for PHP scripts, you need to call the file \".php\", otherwise they will not be parsed as PHP scripts on the webserver (but I think you\'ve figured that one out already). P

from what I have done with PHP under DW, I think you need to do at least these steps to display your records: - set up a recordset (in the Server Behaviours), check the options and OK - select dynamic Texts in Server Behaviours (I think that\'s what you want to do here) and specify your result set depending on what has been chosen on your wishlist pick form. You need to tell DW when you set up the dyn text which form field depicts the reults record set (like writing the SELECT yourself). ll in all, this doesn\'t sound very difficult. get a book on it. I can recommend \'Dreaweaver Foundation\' from FriendsofEd. It\'s a good book detailing DW and DW/PHP/mySQL basics. For more stuff on PHP/mySQL, get \"PHP and mySQL Web Development\" from L.Welling and L.Thomson. P

hi there, how do you position the tables ? do you use Layers (ie CSS) or did you just dump them into the code. If you use CSS (which I guess you do, as you know DW a bit), it might be worthwhile having a play with the settings. Just a thought. P

thanks effigy - think I\'m a step further now. running \'status\' in mysql now says I\'m logged in as root@localhost. many thanks, PM

I\'m really losing the will to live here. I\'m now into my 2nd installation of mySQL under OS X 10.2.8. My first install was removed using Marc Liyanage\'s removal script and did a nice and tidy job. 2nd install went fine, I managed to do a test connect using I then went ahead and did (as recommended) the setting of the password for the root user via: And now (just as before in the first install) I can\'t connect to the database using the root user. the following line /usr/local/mysql/bin/mysql --user=root mysql comes back with ERROR 1045: Access denied for user: \'root@localhost\' (Using password: NO) which suggests that I haven\'t set the password... but I have (see above) Oddly enough, I can connect to mySQL using the mySQL user (standard in OS X 10.2) via: but I can\'t really do anything as any attempt to create for example mysql> INSERT INTO user VALUES(\'localhost\',\'root\',PASSWORD(\'some_pass\'), -> \'Y\',\'Y\',\'Y\',\'Y\',\'Y\',\'Y\',\'Y\',\'Y\',\'Y\',\'Y\',\'Y\',\'Y\',\'Y\',\'Y\'); results in ERROR 1046: No Database Selected What am I doing wrong ? help !!! PM