|
|
Posted by Chris on 10/10/10 11:51
I think I'll just keep posting here until I get everything right - because
every time I post, I figure out the answer within the next 20 minutes or so
(or at least most of the time). I discovered that at some point when I had
edited it (several times) I had left out the WHERE (duh):
:)
Chris
"Chris" <designerNOSPAM@centurytel.net> wrote in message
news:e7uduo$bf7$1@news01.intel.com...
>I now have it showing in the content section of the current page, however I
>still don't have it set up to display more than 1 page. I am working on
>that....but I have discovered that my query isn't working well in the PHP
>display, but it works just fine in my SQLyog query analyzer. I am querying
>2 tables - one with the actual links which has a foriegn key to a table
>that lists the project that the page is related to. I have tried several
>joins - using a RIGHT or INNER JOIN I get the proper result in the query
>analyzer of only 2 links which both relate to only 1 project. However,
>when I run this same query in PHP it gives me the same set of links to
>every project (cartesian product). Is this a PHP issue, and if so, how do
>I handle it?
>
Navigation:
[Reply to this message]
|