Hello all,

I am in school to get a web developing certificate and for our final project we have to make a website. I was thinking of making a realtor's site. We have to incorporate the following into our site: HTML, CSS, ASP Classic, JavaScript, and it has to have a database.

Do you guys use databases for members to your sites? Do you guys use a database of houses for sale? I just need a little guidance on how I could go about doing this site.

Thanks

I'd say the majority of people here who do use a database are probably using MySQL.

__________________
Webmaster & Media Megalomaniac
Fripp Island Real Estate dot com

Well, the html/css/asp/java are simple enough for you. As for a database, you can create a mock up of an MLS.

Most of the time, the database most realtors use is the insanely huge MLS for their local area.

__________________
If you're not remembered, you never existed.

This http://www.open-realty.org/ has a complete real estate website that utilizes mysql, php, etc. It is open source (free) and has installation instructions.

Maybe installing something like that will let you see what is involved in setting up a db and pulling info from it to display in a web page. You could use it as a guide to get started and then make your own.

Thank you so much for your help.

We have only used Microsoft Access for the DB, but RESynergy I will definetly look into that site and read up on it. Brandon, creating a mock up was exactly what I was thinking of doing.

Well Thank you once again to all of you for your help!

if you're using ASP classic, than using a Microsoft database would work best for you. I don't personally like microsoft's products for programming and database, but what can you do?

Access is a small database and my guess is that you can get your hands on this pretty easily. For you're purposes, it would probably be the easiest to use because you can set up your computer at home with IIS, and create and test it there, then easily move all the file including the DB to school.

Make sure you create a diagram of your table structure before you ever sit down and make a single table in your database. I use the ER diagram structure, and I draw it all out on a white board. Then I look for things like many-many relationships. These will cause you lots of problems in your coding, and you should find a way to break out your table structure to make a many-many relationship into two one-many relationships.

Hope this helps.