[PHP-DB] Formgenerator?

2003-01-02 Thread Max Seegräber
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

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

2003-01-02 Thread David Eisenhart
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 > __

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

2003-01-02 Thread Bernain, Fernando G.
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

Re: [PHP-DB] Formgenerator?

2003-01-02 Thread Jason Wong
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

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

2003-01-02 Thread Phanivas Vemuri
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] Please help - Managing relational tables using PHP

2003-01-02 Thread Ryan Jameson (USA)
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 ...

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

2003-01-02 Thread Phanivas Vemuri
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

2003-01-02 Thread Michael Knauf/Niles
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

[PHP-DB] Drawing Chart

2003-01-02 Thread Allens
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

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

2003-01-02 Thread Max Clark
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

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

2003-01-02 Thread Matthew Moldvan
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] Re: postgresql vs mysql

2003-01-02 Thread Diggy Bell
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