OK, so I thought about possibly trying PostgreSQL, but then remembered the main reason for staying with MySQL is that it is what my hosting provides.
So, now I'm trying to develop this database for an antiques store where one item could be in multiple categories, and I think I've gathered enough (almost) to lay out the structure and was almost there. But now I've realized that the foreign keys seem to actually need to be defined in the database. I then found that apparently I need to use the InnoDB type to do that? Then I go to look at my webhost and I only have options for MyISAM, Heap, ISAM and Merge. So... Can someone please confirm that I'm more or less on the right page with this thinking and tell me if I've overlooked something and/or what they think my best option would be? I would rather not change my webhost... Thanks! Levi -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
