|
Hi all,
To cut a long story short folks, I've duggen myself a little bit of a grave. I've got 3-4 weeks to build a website that is able to pull information out of a database from university. The server is that of the university, were provided with all the following platforms am I right in saying:-
Remote Server
IP = 149.170.31.189 OS = Windows2003
WEB SERVER
Microsoft IIS
MIDDLEWARE
Microsoft ADODB
DATABASE
Oracle 8i
The tutors have even provided us with the sql code to create the tables we need and data to go in these. These have been run in the university Oracle, and the tables are created. There are 12 tables created all together:-
(Table 1 ec_artists)
artist_id
artist_name
(Table 2 ec_labels)
label_id
label_name
(Table 3) ec_formats
format_id
format_name
(Table 4) ec_styles
style_id
style_name
(Table 5) ec_tunes_artists
tune_id
artist_id
(Table 6) ec_tunes
tune_id
label_id
format_id
tune_name
tune_price
tune_year
tune_description
tune_copies
tune_mp3
tune_img
(Table 7) ec_orders
order_id
customer_id
order_placed
order_shipped
(Table 8) ec_customers
customer_id
customer_fname
customer_lname
customer_addr_line1
customer_addr_line2
customer_addr_city
customer_addr_pcode
customer_addr_country
customer_email
customer_phone
customer_password
customer_newsletter
(Table 9) ec_items
item_id
order_id
tune_id
item_copies
(Table 10) ec_tunes_styles
tune_id
style_id
(Table 11) ec_tunes_bitstaff
tune_id
bitstaff_id
(Table 12) ec_bitstaff
bitstaff_id
bitstaff_fname
bitstaff_lname
These tables we need to modify later. But at the moment having 3 weeks before the assignment is due in I want these tables running in my website firstly before I start modifying them for higher marks. What I want to be able to do is the following. The html pages are all created. I have a left frame which is constantly there with all my website links. On here I want a User ID & PASSWORD thingy-me-bob for registered users to get in. There also needs to be an ADMIN AREA where only I can modify stock and stuff on the website (don’t know a thing about this). Once in the website the customers should be able to select stock etc basically extract it from the tables created within Oracle. Please some one HELP HELP HELP. We need to use asps and I have no real knowledge. PLEASE HELP. I’m willing to drop £50-100 to a helper at the end of March for major help provided, you can how how desperate I am to get this system working. Ultimately I’d like this to be up and running within the next 2 weeks sparing a week for modifications. HELP – my assignment brief is available via e-mail for a detailed explanation of the above.
HEEEEEEEELP
Cheers
Ash.
|
