philoertel

Are you asking how to write the query? select sum(Gesamt) from Earnings where Date='14.10.2009' and Shift='V' (I used Earnings because I can't tell what your first table is called) or you could get it all in one go: select Date, Shift, sum(Gesamt) from Earnings group by Date, Shift

The problem might be this line: $Subscribe = Trim(stripslashes($_POST['Subscribe'])); If the box is unchecked, the browser won't send the Subscribe parameter, and PHP will emit an error of level E_NOTICE when you try to access the undefined $_POST index 'Subscribe'. Try this instead: if (isset($_POST['Subscribe'])) $Subscribe = 'Yes'; else $Subscribe = 'No';

That's a good change. A note of caution as you start doing things the OO way: avoid classes with names like MYAPP that store all your application's data and behavior. OOP works best with lots of discrete little objects. Put these constants in a class called something like "Payment". Put that $status variable in there too, along with functions like getStatusText(). You'll have other objects like Order, Customer, and Product, and you'll have a devil of a time figuring out what code and what data goes where, but you'll end up with an OO application that's easier to understand and maintain.

Could you post your .htaccess file and the Zend_Router code you've written?