[PHP-DB] upperCase

2001-03-11 Thread Hoo Kok Mun
Hi, I am using mysql-3.22.32 with php4. I have a little problem with the uppercase. I wanted to display a user input field in CAPS. This is what I did and it did not work. $userfield = upper('$userfield'); echo "User Field - $userfield"; Errors (tried both ucase and upper) Call to undefined fu

[PHP-DB] Number of working hours in a month.

2002-03-02 Thread Hoo Kok Mun
Dear all, How do I dynamically calculate how many working hours in a particular month? Has anyone do it before? Here is the simple formula. Add - Number of days in a month Deduct - Sundays Number of Mon-Fri in a month * 8 hours Number of Sat in a month * 4 hours My Figure = total working hours o