sosdios
-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by sosdios
-
-
If you want to read a simple explanation of foreign keys and how to use them appropriately, here's a pretty simple explanation: http://eliacom.com/wpForeignKeys.php. Once you've read through that, let me know if you're still have issues and we can work it out from there.
mysql join with a count query on the 2nd table
in MySQL Help
Posted
@Shoz, There are a bunch of MYSQL front-ends that can make it easier to use and can ensure proper database structuring and management. http://www.Eliacom.com has one that has a built in query browser where you can do some testing and also be able to see what effects it has pretty easily. There's also http://www.vfront.org/ which is a bit more like phpmyadmin, but is a little clunky for my taste.
Hope that helps!