Loads of help required!!

[mulesy]

If anyone can help me id be so greatful..!

Basically i have this project to do for uni and im so stuck its unbelivable.

I have to design a database, which i did last year and have no idea how to even begin, ive done a dvd business

So i need the database to work out how much stock there is, so when someone orders something online its taken out,

The other problem is the website i have to do a a shopping cart and when u click buy it takes it out the database?

Can anyone be of any help my msn is mulesy16@hotmail.com

And if anyones a wizz please please help

Many thanks in advance
Jas

 

[fitzjj]

php and mysql.

when customer clicks order button it updates the record for that dvd decrementing its quantity in stock field and incrementing its reserved field. I wouldnt have thought you would take it out of the database until it had been shipped. So some backend software/page should do this once it is shipped - i.e. decrement the reserved field on shipping

As for calculating stock you can just read the stock field of your DB.

What databases have you worked with before? (mySQL, access etc...)

Ever coded php before?

what you studying at uni?

what web technologies have you used before? (Perl, JavaScript etc...)