Hi All
I am planning to build a website on dreamweaver with a database linked to it for a uni project. The database is going to contain media items (ie sound, pictures) which will need to be linked to website. Can anybody recommend a suitable database application to do so(ie Access, asp)

when u say its gonna contain media items, are you looking to have them embeeded in the db as OLE objects, or you just pointing to them with a url (much easier)

all depending on size of DB, traffic its going to be getting hit with will make your choice for you.

access is fine for very low traffic sites, doesnt cost a penny, and is simple to set up.
mysql is the next step up, db will handle lots more info and traffic, free source, but some hosts will charge for setting it up.
and the big boy of the lot is sql server, expensive, but very robust.

regards
Dave

Would php or asp be suitable especially if i wanted to include a shopping basket within the site as well?

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>when u say its gonna contain media items, are you looking to have them embeeded in the db as OLE objects, or you just pointing to them with a url (much easier)

all depending on size of DB, traffic its going to be getting hit with will make your choice for you.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I agree with Dave, you need to know if you will warehouse (data) binary objects, making your DB jump in filesize, or just have data that points to the media (smaller and more manageable).

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>access is fine for very low traffic sites, doesnt cost a penny, and is simple to set up.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
...runs on Windows server hosts.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>mysql is the next step up, db will handle lots more info and traffic, free source, but some hosts will charge for setting it up.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
...runs on Linux/Unix/Windows hosts, but windows hosts are less to have it installed by default.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>and the big boy of the lot is sql server, expensive, but very robust.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
...Windows hosts, 99% of the time has monthly fees, great features and very fast...until MySQL 4.1/5 comes out (not for a while), then MySQL will also have <i>Stored Procedures</i>, <i>Triggers</i>, <i>Views</i>, and other cool (wanted) features to compete against larger database engines.

It will proberly have urls pointing to them

Ok, so now what <i>Server Model</i> language will you use? (PHP, ASP, ASP.NET, ColdFusion, JSP)

Then your database options will shrink or grow.

Not Sure, any recommendations???

if its a small project go for asp/access free and easy to build.

had a small cms running over an average of 400 visitors a day
with no probs, its the concurrent connections u have to watch, if it gets too high, it will crash.

medium sized up id go for php/mysql

regards
Dave

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>Not Sure, any recommendations???<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Dave words ring true.

Also, it's about your hosting limitations - firstly, <b>Operating System</b> (Windows or Linux/Unix). The DMXzone hosting company here (MaximumASP) are really good, not cheap but damn good/reliable for Windows/ASP/ASP.NET/SQL Server hosting. So if you need heavy ASP box, check them out and use DMXzone as a referer. Honestly, if you are going to use an Access DB because that's fits more, then I'd use a small Windows provider.

Also, you have millions of Linux/PHP/MySQL options globally. <img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle> <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Thanks for the help guys, guess i'll be using php

PS. WHich software do i use, and any recommended text to help me?
Cheers!!!