[PHP-DB] Re: JOIN question

On Wed, 28 Jul 2004 14:00, Chris Payne wrote: Hi there everyone, I'm transferring a client's product from a Visual Basic .NET ACCESS 2000 application to run on a custom install of Apache/MySQL/PHP which I created (With a custom installer which sets everything up for them). My

[PHP-DB] generating reports in php

hi, Is there any product to create reports in an easy way like Crystal Reports or Access? I want to create a report that can be stored in XML and I want to insert this reports to be web available. Advices?? thanks in advance CArlos -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] generating reports in php

First, describe more details about reports such you need. Second, please, do not start new topics by replying on existing. It breaks strukture of mailing list and makes view of topics complicated. Carlos Merino wrote: hi, Is there any product to create reports in an easy way like Crystal

Re: [PHP-DB] generating reports in php

Sorry for my mistake, I need reports based on information stored in a mysql database, I need an easy way to produce tipical reports with header, footer and several detail groups I don´t need graphics, only a functional way to generate the reports storing them in XML...in fact I'm asking if is

[PHP-DB] MySQL software question

Is there a piece of software that will allow my to create MySQL databases and table relations in a graphical format without having to connect to the database? I am looking for something where I can point and click the creation of tables and easily create several relationships between tables (

Re: [PHP-DB] MySQL software question

May be ERwin or BPwin can help you. imho ERwin works with MSSQL, Access, so maybe new versions work with MySQL too. Vincent Jordan wrote: Is there a piece of software that will allow my to create MySQL databases and table relations in a graphical format without having to connect to the database?

Re: [PHP-DB] MySQL software question

I have ERwin 4.1.2208 installed, and it connects to MySQL only through ODBC, so one needs to have the MyODBC.dll installed. You can then make an ODBC connection with it. But ERwin is probably a $4,000.00 software package. Pretty steep for an individual... dave May be ERwin or BPwin can help

RE: [PHP-DB] MySQL software question

I've used ERWin recently with MySQL 4.1.x and it works well. It's fairly expensive, but they do have demo versions available. As with any WYSIWYG program you'll probably want to clean up the final product before using it. -Original Message- From: Mikhail U. Petrov [mailto:[EMAIL

[PHP-DB] RE: Session Values Change

Jacob, Here is my solution. At the top, it checks to see if you are passing a new name via a querystring. If not, it checks to see if a name is present in the session yet. If not, it initializes the session to Jacob. It puts the session's value into the variable $view. If you passed a name,

[PHP-DB] Re: generating reports in php

Hello, On 07/28/2004 05:50 AM, Carlos Merino wrote: hi, Is there any product to create reports in an easy way like Crystal Reports or Access? I want to create a report that can be stored in XML and I want to insert this reports to be web available. Advices?? Try Agata reports:

Re: [PHP-DB] MySQL software question

Vincent Jordan wrote: Is there a piece of software that will allow my to create MySQL databases and table relations in a graphical format without having to connect to the database? snip Try DB Designer from Fabforce - it has it's idiosyncracies, but it is free, and I use it without major

[PHP-DB] php mysql dates

Hi all, currently I have a form which prompts for the user to choose a date. The dropdown lists are stored into variables: $month//e.g. January, February, ... $day //e.g 1 - 31 $year //e.g. 2004 (four digits) then combined into $articleDate How can I

RE: [PHP-DB] php mysql dates

Sure I understand Y-m-d. But won't the database cry because the Month is in text format? (January, february)? Thanks again. Subject: Re: [PHP-DB] php mysql dates On Wed, 28 Jul 2004 14:30:24 -0700, Irm Jr [EMAIL PROTECTED] wrote: Hi all, currently I have a form which prompts for the

Re: [PHP-DB] php mysql dates

On Wed, 28 Jul 2004 14:39:01 -0700, Irm Jr [EMAIL PROTECTED] wrote: Sure I understand Y-m-d. But won't the database cry because the Month is in text format? (January, february)? Thanks again. Whoops, I should read *all* the text of the question... Easiest way to deal with that, IMHO,

RE: [PHP-DB] php mysql dates

I would suggest creating the select dropdown so that the value is actually the numeric value of the month. i.e: select name=month id=month size=1 option value=01January/option option value=02February/option . . . /select Then you can do a simple concat before adding to the

RE: [PHP-DB] php mysql dates

Thanks for the replies. I believe I have two solutions now! Take care. Much apprecitated. -Original Message- From: Swan, Nicole [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 28, 2004 2:48 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] php mysql dates I would suggest creating

Re: [PHP-DB] php mysql dates

Dear Irm Jr, Here are two functions:: http::/www.php.net/strtotime http::/www.php.net/mktime using these functions togethor you can do the need full. BTW why not store just unix time stamp in mysql database. Most People use a string field in mysql database to store timestamp, it simply work