(1) I can write raw HTML
(2) I can create raw MySQL tables with appropriate fields

I want to be able to:

(a) Enter data into the MYSQL tables via web page
(b) I need the user to be authenticated for database access
(c) I want the public user to be able to sort the information by picking "sort by" info and display, both test and graphics or embedded video, etc.

A site that do something like this would be a top ten site.
An example would be topwebcomics.com. The comics are entered by individual web site or web comic owners via login. Public users can vote for their favorite web comics everyday (no login required). The vote count automatically updates and automatically re-orders the list. The web site administrator is not required to do anything, it's all automatic.

Another example. Let's say I want to enter all pet store in the US (authenticated users). The public can view the whole list or sort by any criteria (for example, city, state) and dumps the data into a formatted html page (so that the data doesn't look like a spreadsheet data dump.

Another example. Let's say I want to make a list of all performances of all indie bands in the US. Each band can enter their own info and update their show dates, times and venue. The public can search on any criteria, agai, by stae, cite, dates, price, type of music, etc.

And, I want the info to auto-update when entered and be able to be edited as needed.

So, is that way too complicated to do? Or is there software out there that does it already and it's not worth trying to make a product that probably has a limited audience?

In conclusion, what I would like to see is:
- data entry into MySQL (with or without authentication) on a formatted web page
- data retrieval from MySQL (soted and filted by user input)
- display resulting list in a formatted web page.

Just a thought...

I have the same need....
If anyone has additional on this information let us know
Thanks
Gary Grooms

Software like that does indeed already exist. it is used on classified ad sites, file sharing sites, property rentals etc.

You need some basic php and mysql skills to set it all up and configure it properly though.

Yes Please, definitely gets my vote and I would pay for it too. While there might be other software products out there to do this, a software tool that fully integrates and works with all the other CoffeeCup Software would be fantastic.

I develop Turnkey Database applications using Microsoft Access 2003 & VBA but I am struggling with how to do just this using MySQL & I really don't want to learn another Database platform. Unfortunately while the ISP that I use for hosting is the best in New Zealand they do not support Access Database Hosting (MySQL for Linux Hosting & Microsoft SQL Server for Windows Hosting only) so I am left with the daunting task of understanding and learning MySQL?

A front end product for MySQL that works much like Microsoft Access but supports all other existing CoffeeCup Software & Tools might just be the ticket here!

This all sounds like CMS functions.. or like Will says, "You need some basic php and mysql skills to set it all up..."

What is Access supposted hosting? Throw that puppy on the Windows server and connect via an ASP Script. At least that is what I did to get Snitz forums working from my home server at one point in time.

learn php

Yes, and you won't have to deal with MS...What did you call it, Pixie?

Those words are too rude for here Tom

Hey, consider downloading MySql community server from MySql.com, also download the MySql Workbench.
Also get the MySql network connector from the extentions..
The workbench gets you the interface to your databases.

BUT, now look at OpenOffice.org for the office suite and start working with BASE.

You don't want to go back to MS office anymore.

At our company we are changing to opensource software.

I hope you will find this helpfull
Loed Ruijtenbeek
From the beautifull town of Dordrecht, the Netherlands.


Ps. we desperatly need that datepicker.