Apple or AMD means nothing to RAM. What you need to pay attention to is the manufacturer QVL, or qualified vendor's list for memory. That list states all the memory makes and combinations that were tested by the the motherboard's manufacturer.
The LGA 775 chipset typically uses DDR2 800MHz (PC2 6400). The fastest available is DDR2 1066MHz (PC2 8500). Your motherboard manual should have a QVL chart in it listing all the compatible memory makes (Corsair, G.Skill, Kingston, etc.) and capacity combinations (2x 4GB sticks, 4x 4GB sticks, etc), and speed variations (DDR2 533, 667, 800, 1033).
But I will say this: always buy memory in "kits" of 2x or 4x instead of individually. This means that they were tested to work together at the factory. If you buy two or four individual sticks, they likely were made at different periods and production variations in the silicon may make just a slight enough difference to make them screwy when working together (read: random computer crashes for no reason).