[PHP-DB] Weird Windows SQL

2002-04-24 Thread Michael K. Dolan Jr.
Hi, I just installed MySQL on Windows XP. The winmysqladmin GUI only allows me to create databases that start with test. So, I can create a database called testmydata but I cannot create a database named mydata. This is driving me nuts. Any ideas? Thanks, Mike

Re: [PHP-DB] Weird Windows SQL

2002-04-24 Thread Michael K. Dolan Jr.
I can create new databases if I create them from the command line logging into mysql as root. However, I'm new to the GUI and I guess I would like to login to the GUI as root. Do you know how to do this? - Original Message - From: Peter Lovatt [EMAIL PROTECTED] To: Michael K. Dolan Jr

[PHP-DB] dynamic sql

2002-01-24 Thread Michael K. Dolan Jr.
Is it possible to do a sort of dynamic sql. For instance, if I have a form with a bunch of field/data variables and I send them to a php processor, can I just create a loop to have it update all the fields without having to specify each field. In scratch code, I guess I'm looking for something

[PHP-DB] dynamic sql

2002-01-24 Thread Michael K. Dolan Jr.
Rich, thanks. I got the dynamic sql to work (i had a syntax problem), now my problem is what's the most efficient way to loop it through all the form fields that are passed to the processor? This is my current sql statement which handles 1 field: $sql_update = UPDATE md_users SET .$formName. =

[PHP-DB] WebMail

2002-01-14 Thread Michael K. Dolan Jr.
Hi, I'm looking for a good web based email client (preferably easy to setup and done in PHP of course). We have a sendmail server that works great. I'm not sure how the webmail systems work though. Can I use a different Apache server or do I have to setup the PHP webmail on the actual mail