How could I efficently fill time box in my timesheet?

[rolwong]

Dear all,

I am going to build a timesheet system and here is my database table.

user_id varchar(30)
prj_id unsigned bigint
time_date (Format YYYYMMDD)
time_amount unsigned double (remark: number of hour spent)

How could I get data from database to fill in a specified date box in my timesheet? What is the most efficiency way?

user_id, prj_id, time_date, time_amount
user1, 0, 20070807, 1
user1, 2, 20070810, 4
user1, 1, 20070808, 2

[rolwong]

anyone has idea?????????

[paulnaj]

Hi,

'timesheet' is a bit vague. I assume from your JPG it's some kind of spreadsheet, but you don't mention which.

Which bit of PHP do you want help with?

P.