1. You have to play with this stuff a bit -- download and install MySQL on your local machine and play with it until you're comfortable.
2. Get a copy of phpMyAdmin, ftp it to your server and install it. It allows you to execute SQL statements on the host.
3. If you're not at all familiar with SQL, there are some really great tutorials and examples. Julie Meloni has some excellent ones at www.thickbook.com; there are others at DevShed / WebMonkey / Zend, etc.
4. As far as the results of a JOIN are concerned, within the context of a normality, there are subtle differences between say LEFT ... INNER and LEFT ... OUTER in terms of what gets included. This is why (1.) is so important.
5. Learning JOIN syntax is probably the best route to follow, but WHERE clauses will also do the trick.
HTH - Miles Thompson
PS 6. There are some very good SQL sites out there as well. Check out anything by Joe Celko, keeping in mind that MySQL doesn't have subqueries. /mt
PPS 7. The question really is one for a MySQL list. <g>/mt
At 09:27 AM 5/18/2003 -0400, David Shugarts wrote:
I, for one, wish you would not treat us like dummies just because it is impossible to understand the arcane crap that makes SQL freaks so happy. I have read Chapter 6 and it is a pile of useless garbage to me until I can get some practical examples, which are sorely lacking in the mySQL world.
I spent several hours with Chapter 6, BTW and successfully called JOIN statements, but it doesn't answer my basic questions. The result of the JOIN doesn't look at all like what an ordinary person would expect.
Further, we are caught in a server environment that demands we figure out both mySQL as well as PHP, with people on both lists telling us to go to the other list because "that question has nothing to do with PHP."
Give us a BREAK!
--Dave Shugarts > >> I'm kinda new at this stuff, so this might sound like a dumb question, > but >> How would i go about linking two mysql tables? > > Read the MySQL Manual... this has nothing to do with PHP. > > Specifically read the SELECT and JOIN sections in Chapter 6. > > ---John W. Holmes... > > PHP Architect - A monthly magazine for PHP Professionals. Get your copy > today. http://www.phparch.com/ > >
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
