Member Avatar for mulesy

Hi there,

I am relatively new to MYSQL and i have to design a database for stock for a dvd firm, this database has to link up to a website, the website is a DVD firm so the only things that needs to recorded in the database is how much stock is available.

so basically when i click buy from website it takes you to a payment page you can click confirm or decline when you hit confirm it says thank you for the purchase and takes it from the database..But how do i do this???

But i have no idea how to even start this ive been stuck with this for ages now and really have no idea what too do if anyone could help me out id be very grateful, i have webspace so can host anything.

Can anyone help me?

  • 4 Contributors
  • 3 Replies
  • 177 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by sibotho
Member Avatar for robbyd

sounds like you basically need to update the database everytime theres a purchase.

so if you have a table in mysql with the dvd name and the current quantity
a basic sql query can do this:

$sql = "UPDATE table_name SET quantity = quantity - 1 WHERE dvd = 'name of dvd'";
Member Avatar for bhuvan83

for that u need to do coding on ur webpage so that it connects to the database

Member Avatar for sibotho

Hello all

I am new on this site and i don't know where to click in order to be able to post. Sorry newbie for posting my message inside yours.
Can somebody tell me, Is visual Studio 2003 compatible with mysql? I am doing my final year project using VS 2003, I would also want to know How do I do the connection between the 2. Please help and Thank you in Advance.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.