Date storing for an action made? |
Date storing for an action made? |
xxkasperxx |
Apr 17 2013, 08:03 PM
Post
#1
|
Serious Coder Group: Members Posts: 261 Joined: 30-April 11 Member No.: 14,449 |
How can I store the date that someone entered somthing?
I have a table with the rows of Name | ADue | APay | Date | Email | Percent | Notes | So basically when someone pays, I go in and then put that in, and it auto fills the date, but how do i Store that they payed 12.00 on 4/17/13 and then also have 3.00 stored on 3/5/13 ? Does that make any sense? I will be doing all of the adding and query's through PHP, but for now I am setting up everything with phpMyAdmin. |
xxkasperxx |
Apr 17 2013, 08:28 PM
Post
#2
|
Serious Coder Group: Members Posts: 261 Joined: 30-April 11 Member No.: 14,449 |
I figured it out, I create a table for each person, and then create a new row each time something is inserted..
|
Christian J |
Apr 17 2013, 10:14 PM
Post
#3
|
. Group: WDG Moderators Posts: 9,679 Joined: 10-August 06 Member No.: 7 |
I'm no good at DB:s, but couldn't you also use a single table with a new row for each date?
Maybe the best approach depends on how many persons and/or payments there are. |
Brian Chandler |
Apr 17 2013, 10:43 PM
Post
#4
|
Jocular coder Group: Members Posts: 2,460 Joined: 31-August 06 Member No.: 43 |
I figured it out, I create a table for each person, and then create a new row each time something is inserted.. If this is a very small ad hoc arrangement this may do, but it isn't really the way to handle things. You need a table of *customers*, including name, address, etc., then a table of *transactions*, including date, amount, customer code etc. |
Lo-Fi Version | Time is now: 5th June 2024 - 12:02 AM |