blurMember wrote:
in detail, i have two tables, 1 is products details and the other is order details. so the totalprice n quantity are meant for the order details table.
I see. You might consider copying the price from the products table to the order table at the time of the order, so that the orders doesn't change if the product changes.
blurMember wrote:
both the field names are spelled correctly.
The database begs to differ... ;) Debug the application and look at the query that you created, so that you see if it ended up the way that you expect.
--- Year happy = new Year(2007);