Probably because the dates stored in your actual database are just that. Dates. (ie January 4, 2008; December 16, 1908; etc)

The dashes(-) you see when you retrieve results (ie SELECT date FROM...

Hi again! Maybe you can try reading this: some-thread-on-sums (http://forums.devshed.com/ms-sql-development-95/how-to-query-from-two-tables-sum-up-field-values-562579.html).

Or this one @ daniweb...

oooh...

article on using triggers (http://www.devarticles.com/c/a/SQL-Server/Using-Triggers-In-MS-SQL-Server/).

Perhaps send an email to yourself when 1 row is updated after the adduser query?


... php code for query...

if @@rowcount > 0
... php code for mailing the admin

I think what you can do on your work_machine table is have references to the workid and machineid...

work_machineID | workID | machineID
1 | A | 1
2 ...

There is something called 'case expressions' in MS SQL queries...

This article is a bit outdated (http://www.craigsmullins.com/ssu_0899.htm) but it still makes a lot of sense. Jump to the "A more...

I was thinking you could do it by joining the table to itself. But then you have the problem of not knowing if the page you're looking up is in the 3rd or 4th level of 'childhood'.

Anyway, this is...