Quote: Is it actually

teammatt3 — Fri, 18 Jan 2008 16:33:06 +0000

Quote: Is it actually possible to use PHP myadmin with an Access database?

Probably not. But you can use MS Access to control a MySQL database, which can be controlled by PHPMyAdmin too.

drew wrote: Is it actually

JeevesBond — Thu, 17 Jan 2008 20:59:24 +0000

drew wrote: Is it actually possible to use PHP myadmin with an Access database?

I very, very, very much doubt it. It's called PHPMyAdmin for a reason. You should check their documentation, or ask on their forums though. You never know. The biggest problem is that it's difficult to use more than one database system in PHP, without making a special effort.

drew wrote: Also, has anyone got any advice on how to structure a database that stores student attendances?

Sounds like a many-to-many relationship and a one-to-many storing class names. Four tables:

student
- sid
- student_name
- ... Other fields ...
student_classes
- sid
- cid
- attended
classes
- cid
- nid
- class_time
- ... Other fields ...
class_info
- nid
- class_name
- ... Other fields ...

This is just off the top of my head, your schema will be different depending on the project requirements. Speaking of requirements: wouldn't it be easier to use one of the existing course management systems out there? There are a few good Free software ones (Moodle for example).