Integrate a mysql query into another

norok · #1 22-Jul-2003, 03:53

Hallo,
I've this query and want to integrate two others in it
but I ve no sucess:

PHP Code:


<?php
// querys for complete title data
      $result1 = mysql_query
        ("SELECT titles.titleID AS titleID, " .
         "       titles.title AS title, " .
         "       titles.subtitle AS subtitle, " .
         "       titles.edition AS edition, " .
         "       titles.year, " .
         "       titles.isbn, " .
         "       titles.comment, " .
         "       publishers.publName AS publisher, " .
         "       publishers.publID, " .
         "       categories.catName AS category, " .
         "       languages.langName AS language " .
         "      FROM titles JOIN tmpTitleIDs" .
         "      LEFT JOIN categories ON titles.catID = categories.catID " .
         "     LEFT JOIN languages ON titles.langID = languages.langID " .
         "     LEFT JOIN publishers ON titles.publID = publishers.publID " .
         "WHERE titles.titleID = tmpTitleIDs.titleID" );

//Query for standort:
       $result3 = mysql_query 
       ("SELECT name FROM standort LEFT JOIN titles using(standortID)".
       "WHERE titleID");//dont know if it works because
it brings all nemes , and not only the ones corresponding with
titleID

//Query for stadt=town;
$result4= mysql_query
("SELECT stadt, stadtID FROM Stadt WHERE $titleId=titles.stadID")-circa
?>

These last 2 statements should be integrated in the big above.

Help would be great because, I cant find a solution.

Thanx,

Norok

norok · #2 22-Jul-2003, 07:03

I changed my code structure,
so I do not need a anwser for this thread.

Norok

JdS · #3 22-Jul-2003, 07:25

That's good to hear Norok but would you do me the favour of posting your solution?

You see, this thread will be found on the search engines (Google, MSN, AltaVista, etc) sooner or later and anyone having the same problem as you had, might find the information useful one day.

Danke.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
help upgrading mysql	vher	MySQL / PHP Forum	1	25-Sep-2003 06:49
A problem Between MySQL <> phpBB	mirable	MySQL / PHP Forum	3	10-Sep-2003 06:31
Windows: From only £20p/y,Linux: from $10p/m. ASP, ASP.NET, PHP, Free MySQL, +More	EyotaHosts	Web Hosting Advertisements & Offers	0	28-Jun-2003 14:54
Search Engine Positioning 101 and 201 "How To" Tips...	000	Search Engine Optimization Forum	0	29-May-2003 11:34
MySQL Adds Subselects, Upgrades Performance and Security	JdS	MySQL / PHP Forum	4	22-Jan-2003 18:42