Re: linking mysql tables

Thanks, Miles! Because it looks to be an honest attempt to help, I will pursue every one of your leads here and see what happens. I have done (1) and (2) already. You may not see that a lot of us are coming at the task from the perspective of being hosted on Linux/Apache servers that have mySQL and phpMyAdmin installed. Since these are the facts of life for us, we struggle to understand and then use the tools supplied. I was thankful to find that phpMyAdmin lets me create and edit a database and "play with" mySQL statements, but for my website users, I must quickly get to HTML pages that work. So I am forced to learn some mySQL and some PHP, but must subscribe to two different lists and I must be careful never to ask the wrong question--e.g., any question that requires integration of mySQL and PHP. Yet, that is what a lot of us are trying to do--work with both mySQL and PHP, to achieve a web page that works. Accepting that mySQL does not do subsorts, what do people actually do when they need to accomplish essentially a subsort? Can you point to someplace where this is explained? Thanks, Dave Shugarts > > OK - here's the break. > > 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 >