While your iPhone is connected, open "Image Capture".
Select your iPhone in the devices list and use the drop-down menu at the bottom to select "No application".
That's for Snow Leopard, for Leopard you'll need to search the net for an applescript called "cameraconnected" or something like that...