I used InnoDB for a while and just recently finished switching everything back to MyISAM. It was really hard to reliably back up and if you ever decide to set up replication forget about it....

Your primary key is already indexed by default. Creating a second index just wastes memory but should not decrease performance. If you want to know more on how MySQL handles indexes check out their...

Your syntax looks okay at a glance. Try encapsulating your table and field names in back ticks and be sure to have single quotes around your strings... for example:

"SELECT count(`id`) FROM...

Maybe this will help you...I use it for generating a parts book from mysql and our employee handbook. It's pretty nice.

http://www.ros.co.nz/pdf/