Re: Looking for a more efficient way to achieve the same result -> Found solution but would still like some advice :)
Richard a écrit : Richard a écrit : Hello, I'm in the process of programming a customer area with a list of subscriptions : Reference | Title | Type | Date of first subscription | Expires Each item in this list will have a link to it's details with will show a list like this : Subscribed on : date of first subscription Renewed on : date of first renewal Renewed on : date of second renewal Renewed on : date of third renewal Expires on : date when expires. At the moment I have got three mysql tables : -- 1) Products Reference | Title | Type 2) Subscriptions number(autoincrement) | reference | date_begin 3) subscriptions details number(autoincrement) | subscription_number | length(number of months) -- To get the first table I would : List subscriptions For each subscription get list of "lengths" which I would add together and then calculate expire date by : Total "lengths" + date_begin Which gives me the expire date. However all this seems alot of queries and resources for such a small list and as I have not started the programming yet and have not created the tables either, I thought I might ask your advice to see if you think this is the best way, or if you could think of a better way of achieving the same result. Maybe there is a way to get the expire date with mysql, or maybe I should rethink my tables? I hope that everything is clear, and thanks in advance :) Hi I might have found a better solution. I could have one table for the latest details and another containing the history. I would still have two tables, but only one query when a customer wishes to view his or her subscriptions and only one query when he or her views the detail. What would the best way to copy an entry from one table to another and then change the entry value ? What is the best way to do this using a minimum of queries? To copy an entry from one table to another do you have to read the value with one query and then insert the value to the other table with a second query or does mysql (5.0) have a function to copy data from one table to another. Thanks in advance. Hi me again, just to say I think I've found the solution : INSERT INTO TABLE2 SELECT * FROM TABLE1 Do I have to do two queries : INSERT INTO SUB_HISTORY SELECT * FROM SUB WHERE num = '$subnumber'; and UPDATE SUB SET end_date = '$newdate' WHERE num= '$subnumber'; Or is it possible to do both queries in one ? Thanks :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for a more efficient way to achieve the same result
Richard a écrit : Hello, I'm in the process of programming a customer area with a list of subscriptions : Reference | Title | Type | Date of first subscription | Expires Each item in this list will have a link to it's details with will show a list like this : Subscribed on : date of first subscription Renewed on : date of first renewal Renewed on : date of second renewal Renewed on : date of third renewal Expires on : date when expires. At the moment I have got three mysql tables : -- 1) Products Reference | Title | Type 2) Subscriptions number(autoincrement) | reference | date_begin 3) subscriptions details number(autoincrement) | subscription_number | length(number of months) -- To get the first table I would : List subscriptions For each subscription get list of "lengths" which I would add together and then calculate expire date by : Total "lengths" + date_begin Which gives me the expire date. However all this seems alot of queries and resources for such a small list and as I have not started the programming yet and have not created the tables either, I thought I might ask your advice to see if you think this is the best way, or if you could think of a better way of achieving the same result. Maybe there is a way to get the expire date with mysql, or maybe I should rethink my tables? I hope that everything is clear, and thanks in advance :) Hi I might have found a better solution. I could have one table for the latest details and another containing the history. I would still have two tables, but only one query when a customer wishes to view his or her subscriptions and only one query when he or her views the detail. What would the best way to copy an entry from one table to another and then change the entry value ? What is the best way to do this using a minimum of queries? To copy an entry from one table to another do you have to read the value with one query and then insert the value to the other table with a second query or does mysql (5.0) have a function to copy data from one table to another. Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Looking for a more efficient way to achieve the same result.
Hello, I'm in the process of programming a customer area with a list of subscriptions : Reference | Title | Type | Date of first subscription | Expires Each item in this list will have a link to it's details with will show a list like this : Subscribed on : date of first subscription Renewed on : date of first renewal Renewed on : date of second renewal Renewed on : date of third renewal Expires on : date when expires. At the moment I have got three mysql tables : -- 1) Products Reference | Title | Type 2) Subscriptions number(autoincrement) | reference | date_begin 3) subscriptions details number(autoincrement) | subscription_number | length(number of months) -- To get the first table I would : List subscriptions For each subscription get list of "lengths" which I would add together and then calculate expire date by : Total "lengths" + date_begin Which gives me the expire date. However all this seems alot of queries and resources for such a small list and as I have not started the programming yet and have not created the tables either, I thought I might ask your advice to see if you think this is the best way, or if you could think of a better way of achieving the same result. Maybe there is a way to get the expire date with mysql, or maybe I should rethink my tables? I hope that everything is clear, and thanks in advance :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]