Ad:

MySQL Discussion Thread
Unsolved
Views: 2557

Apr 30th, 2005

new to MYSQL need help

Expand Post »

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?

Similar Threads

jsp and mysql in JSP
SQL Server vs MYSQL vs MSQL (i'm stopping now) in MS SQL
MySQL for this forum ... in MySQL
MySQL vs. PostgreSQL in MySQL
MySQL-Front - Graphical Interface for MySQL in MySQL

mulesy

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Apr 2005

Permalink

Apr 30th, 2005

Re: new to MYSQL need help

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:
[PHP]
$sql = "UPDATE table_name SET quantity = quantity - 1 WHERE dvd = 'name of dvd'";
[/PHP]

robbyd

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

12 posts
since Apr 2005

Permalink

Mar 16th, 2007

Re: new to MYSQL need help

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

bhuvan83

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

29 posts
since Mar 2007

Permalink

Mar 29th, 2007

Re: new to MYSQL need help

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.

sibotho

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

32 posts
since Mar 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: My Sql Reports

Next Thread in MySQL Forum Timeline: mysql and c# 2003

DaniWeb Message

Cancel Changes

User Name
Password