Re: Search MySQL db with PHP

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@xxxxxxxxxxxxxx> wrote in message
news:e7uduo$bf7$1@xxxxxxxxxxxxxxxxxxx
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?



.

Relevant Pages

  • Re: Confused by mysqli
    ... When I started using MySQL with Perl back in 1998, ... fetch_assocon a query I prepared with bind variables, ... So I had it print out its eval string that it was trying to run. ... PHP will fail to run at all, because bind_result will not have enough ...
    (comp.lang.php)
  • Re: [PHP] PHP & MySQL Problem
    ... [PHP] PHP & MySQL Problem ... > actually there seems to be no problem with your query (besides that you ...
    (php.general)
  • Re: timestamp
    ... PHP newsgroup, and should be discussed in comp.databases.mysql). ... Then click on the Survey link."; ... your SQL syntax; check the manual that corresponds to your MySQL ... Your query fails because a datetime value needs to be in single quotes in the query, ...
    (comp.lang.php)
  • Re: [PHP] Architecture patterns in PHP
    ... 316 Query SHOW TABLES FROM `cake` ... 316 Query DESCRIBE `posts` ... Application and Templating Framework for PHP ... when they cache the results of reverse engineer the object model from ...
    (php.general)
  • Re: [PHP] PHP & MySQL Problem
    ... [PHP] PHP & MySQL Problem ... The query then just goes like ... >> I have a script that collects data from a form and puts together a>> mysql ...
    (php.general)