[PHP-DB] Re: postgresql vs mysql

Ellen, >From a strict database perspective, PostgreSQL has a bit more power than MySQL. In particular, support for transactions (and database integrity) is very complete with PostgreSQL. With that being the case, the disadvantage would be with MySQL, not PostgreSQL. In addition, Tim Purdue (sou

RE: [PHP-DB] select date YYYY-MM mysql help

Sounds more like an SQL question than PHP, but try the following: SELECT * FROM table WHERE date LIKE '2002-12%'; Regards, Matthew Moldvan --- System Administrator Trilogy International, Inc http://www.trilogyintl.com/ecommerce/

[PHP-DB] select date YYYY-MM mysql help

Hi all, I would like to do a query like this from mysql: select * from table where date = '2002-12'; However unless I have the complete date '2002-12-26' the query doesn't work correctly. What else do I need? Thanks in advance, Max -- PHP Database Mailing List (http://www.php.net/) To uns

[PHP-DB] Drawing Chart

Matthias, I've pondered this for sometime. I've been abused by PC Co-Workers about the lack of a Chart Generator via HTML on the Mac. What we do is generate the report via PHP/MySQL and distribute the data on the web in a columned table format. Then you just copy the data and field header sec

RE: [PHP-DB] Please help - Managing relational tables using PHP

Well, you can use the "SQL" tab to write a sql statement to do whatever you want, but no, the graphical interface doesn't appear to do that. "Phaniv

RE: [PHP-DB] Please help - Managing relational tables using PHP

Dear Mr. Ryan, May be I did not present my question clearly to you. My question in detail is ... --> Does phpMyAdmin supports / allow / interface, editing data from "one to many" or ,"many to many" related tables, using a single phpMyAdmin interface( a single HTML page) I have a (primary) table

RE: [PHP-DB] Please help - Managing relational tables using PHP

You need to realize that phpMyAdmin is a database manangement tool, not a database. So I'll answer your questions based on the mySQL database ... 1. MySQL 3.23.43b introduced a table type of InnoDB which is the first to allow foreign key constraints. http://www.mysql.com/doc/en/SEC448.html ...

[PHP-DB] Please help - Managing relational tables using PHP

hi all, 1. How does phpMyAdmin manage tables with "one to many" or "many to one" relation ships. Is there any documentation about this. --or- 2. Does phpMyAdmin support editing data from more than one table that have a one to many or many to one relationship

Re: [PHP-DB] Formgenerator?

On Thursday 02 January 2003 20:34, Max Seegräber wrote: > Hi. > > I´m tired of buildung MySQL-input and update forms. Aren´t there any > formgenarator supporting some further features like: > -user events bevor and after the insert > -data checking by RegExp and custom errorMsgs > > I tried PhAkt w

RE: [PHP-DB] How to Make a Pop Up Window and show there a mysql table for help input data?

Es posible, tuve que hacer algo similar pero no me alcanzó solo con PHP, tuve que combinar con JScript... Te sirve?? Fernando Bernain Senior A Business Process Outsourcing KPMG Argentina Tel: 54 11 4316 5754 Fax: 54 11 4316 5734 [EMAIL PROTECTED] -Original Message- From: José Luis [ma

[PHP-DB] Re: Searching DB and Printing Results

This may be of use: http://www.mysql.com/doc/en/Fulltext_Search.html D. "Mike Delorme" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > > > Hi, > > I have a table in DB Music that looks a little mike this: > > TABLE NAME > __

[PHP-DB] Formgenerator?

Hi. I´m tired of buildung MySQL-input and update forms. Aren´t there any formgenarator supporting some further features like: -user events bevor and after the insert -data checking by RegExp and custom errorMsgs I tried PhAkt whicj is cool, but doesn´t support a fieldcheck or events after an inse