Looking for mysql application

[overseerhobbit]

Hi I am greating ready to make a rather large listing site.

What app needs to do is have a front end where the user enters from a secure admin app the name address business description web site link category
county and picture. I then need to have the ability to have a template page to display or sort the entire database by categories/counties etc. It would be very similar to a membership listing that many chamber of commerce sites use. I have found one or two but price is quite prohibitve for a small start up. Any ideas of a good mysql list managment that is fairly cheep.

thanks for the help

[clio]

Check http://www.hotscripts.com

Are you looking for a php/mysql combination? Perhaps you need to make a features list and post it. That would be helpful.

[overseerhobbit]

Yes what I am looking for is either a flat file or a php/msql application.

It is basically a list/category mangament system with the following fields.

name
addresss
description
category
county
email
thumbnail of businesss

it needs the capability to add and delete records in the database on the server they of course need to be password protected.
It needs the capabilty to generate a listing of the entire database sorted by business or by category and it needs to do the same on a county field basis.

I have found a couple of options but do not relish spending the kind of money desired and hoped there was something reasonable or even open sourche out there.

[clio]

It looks like you're looking for Classified Ads Program.

Have you tried any of the programs listed on these pages? Some of these are free.

http://www.hotscripts.com/PHP/Script...ngs/index.html

Those are business specific, but here's some general ones too:

http://www.hotscripts.com/PHP/Script...ral/index.html

What'd I'd look for is the rating and see how many stars each program gets. Some of those high rated ones will be free hopefullly.

Good Luck.

[gerilya]

Yet another thing to consider is approximate size of your database. For 'rather large listing site', text file or MySQL might not be the best choice.

[clio]

text file is definitely not the right choice. MySQL should work fine.

[gerilya]

Originally posted by clio
text file is definitely not the right choice. MySQL should work fine.

Just wonder how you came up to this conclusion, clio.
If you don't have database size estimate and yet comfortable making this kind of statements, it looks like you claim that speed of INSERT/SELECT/DELETE operations do not depend on database size.

How much time do you think it would take to add 1000 new records to the database with 10M records, 300 bytes each?

[clio]

Because I looked at his site and it's rather small. He could use flat file, but mySQL would give him the room to expand.

gerilya, we're not powering google or yahoo here! LOL.

[gerilya]

Oh, ok, I guess I took literally "rather large listing site" and "It would be very similar to a membership listing that many chamber of commerce sites use"

[overseerhobbit]

Its not the goodtyme site. that one is indeed fairly small still. the new one is going to be called countrymusichighway and will be based on eight counties in eastern kentucky listing each business and attraction on the site as well as maintaining a daily calendar for all major events in these counties. I am estimating roughly eight to ten thousand entries in the database. Right now since I can't find anything that suits me in my price range is writing a flat file input system and then some php scripts to display the data as I need it. A friend of mine has written something similar excluding input for a community library in the area that handles book lookups and searches for 35,000 volumes in a flat file and it is pretty quick

[clio]

Ah, my mistake then.
Sorry you couldn't find anything.

Just be careful with flatfiles. My experience, even with smaller databases, has never been pleasant.

[CeleronXL]

Unless you're storing something very small in flat files, don't do it. Anything that has even the most remote possibility that it will have any measurable size will require a database like MySQL. MySQL 4 works wonderfully, and should be suited for such a purpose as this. Unless this database is going to be bigger than hell itself, MySQL will work perfectly.

-php/mysql web developer

[G.Bloke]

Originally posted by gerilya
Yet another thing to consider is approximate size of your database. For 'rather large listing site', text file or MySQL might not be the best choice.

Well my own experience is different. One project in which I'm involved (not hosted on Jag obviously) uses MySQL - the database has 81,818,137 records and has an average of 120,000 queries actioned on it each day. MySQL copes very well with that load.