See inline below...
FYI: I have never used PHP or MySQL.
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================
"Susan" <(E-Mail Removed)> wrote in message news:uIIDouT%(E-Mail Removed)...
> Thanks Thomas, sorry I got it wrong but I knew you had knowledge about PHP though.
>
> I am working on creating a database with MySql and PHP. I abandoned FP because I could log into
> the hosting site from a couple locations and use free FTP tool and not be dependent upon FP being
> installed on PCs. How easy it is to create printed reports from a MySQL database. I began to
> wonder if I should have stayed with Microsoft products. If I had created database with Access,
> then are reports easy to generate?
To generate reports via scripting you are limited to the command available in the lanaguage and your
knowledge/resources for either PHP or ASP, however to use either locally requires that you have a
web server installed so that you can access the PHP/ASP scripts and MS SQL or MySQL Database Server
via http.
With Access, you could always download the database and work with it directly in MS Access or export
the data to Excel.
>
> So I could have used the PHP to create Access database without depending on FrontPage? Then with
> Access, the other Microsoft applications could be used against it? I am trying to evaluate the
> best way to go.
I don't think you can use PHP to create an MS Access database. With ASP / ASP.net you can create a
MS Access database.
So far I have been able to create any functionality in ASP/VBscript that can be similarily create in
PHP, that I have need for my web projects.
>
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> news:u1nfDRT%(E-Mail Removed)...
>> Correction, I work only with Classic ASP and MS Access which requires the site to be hosted on a
>> Windows IIS web server.
>>
>> Under Windows you can also
>> - use PHP with MS Access with IIS
>> - use Classic ASP / ASP.net with MySQL
>>
>> FP directly supports working with Classic ASP / ASP.net / MS Access and MS SQL server.
>> --
>> ==============================================
>> Thomas A. Rowe
>> Microsoft MVP - FrontPage
>>
>> http://www.Ecom-Data.com
>> ==============================================
>>
>>
>> "Susan" <(E-Mail Removed)> wrote in message news:%23%23MVpKT%(E-Mail Removed)...
>>>I know PHP can be used with FP and then MySQL used with PHP. But if one sticks with MS products
>>>would Access correspond to the MySQL and PHP to ASP?
>>>
>>> Are there advantages in sticking with the MS products in that after one has a database created,
>>> the other products could be used to generate user-friendly reports? In other words if one has a
>>> database created with MySQL, how would one generate user-friendly printed reports?
>>>
>>> I know this does not address FP issue but I know that Thomas Rowe knows PHP and others use
>>> Access and ASP with FP.
>>>
>>> Thank you for any information.
>>> Susan
>>>
>>
>>
>
>
Similar Threads
