Database help, how to?

metalguy639 · 05-09-2005, 10:08 AM

I'm really not sure where I should post this thread, so if this is in the wrong place, I'm sorry.

I run a web page & forum for a comprehensive database of information on fan recorded metal music shows. There are 2 things I really need help with.

1) Creating a search field for the page. The page is about 4 gb in size and has over 1000 HTML pages in it, so a good majority of the scripts and things I have found up to now do not support a large area search. I would like some help of a how to on how to set that up on my web page.

2) Creating a database with a user login. Basically I need to create a place for members to register to my web page, login and search other's lists for particular shows they are looking for so they can request the show from the other trader. I have some basic ideas in mind on search capabilities and what they should be able to search for, but no idea how to put it together.

I'm new to making forms work, unless I have a script for them to copy and paste into the HTML. I haven't conquered making them from scratch and from what I've seen, this is what I will most likely have to do. I use MS Front Page 2003 to create my web pages, and the server (host) I upload the server to is run on an apache linux system with MySQL, PHP and many other features. I'm very new to all of this and want to make the best possible, professional looking page I can with all the little things that would be very cool for the page. The link to the page is http://www.metalbootlegdatabase.com and I'm currently working on a "new" look for the site that is quite a bit more sleak than what's up right now. Any help will be appreciated, and please as simple as you can possibly say it.

TIA!
MP

JamieR · 05-09-2005, 11:53 AM

Macromedia Dreamweaver MX 2004 has php/mysql integration and can connect to mysql databases etc

Frontpage is trash (IMO that is)

I would use a mixture of php and mysql to create the login system etc. There are a lot of tutorials around for help on this

Jamie.

metalguy639 · 05-11-2005, 02:06 PM

Thanks. I have Dreamweaver. Can you tell me the differences between dreamweaver and front page as to why you like it more? I'm always up for trying to make my site better and I have used dreamweaver before, but at the time I did not notice much of a difference in them. But then again its been awhile since I installed and used it too.

MP

metalguy639 · 05-11-2005, 04:38 PM

Quote:

Originally Posted by weazel

Macromedia Dreamweaver MX 2004 has php/mysql integration and can connect to mysql databases etc

Frontpage is trash (IMO that is)

I would use a mixture of php and mysql to create the login system etc. There are a lot of tutorials around for help on this

Jamie.

I have another queston for you. Can I create a php page with Dreamweaver by using it as the html editior and creating a page like I would if I were to do it in html format?

MP