GIDForums  

Go Back   GIDForums > Computer Programming Forums > MySQL / PHP Forum
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

 
 
Thread Tools Search this Thread Rate Thread
  #1  
Old 22-Jul-2003, 03:53
norok norok is offline
New Member
 
Join Date: Jun 2003
Posts: 23
norok is an unknown quantity at this point

Integrate a mysql query into another


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
  #2  
Old 22-Jul-2003, 07:03
norok norok is offline
New Member
 
Join Date: Jun 2003
Posts: 23
norok is an unknown quantity at this point
I changed my code structure,
so I do not need a anwser for this thread.

Norok
  #3  
Old 22-Jul-2003, 07:25
JdS's Avatar
JdS JdS is offline
Senior Member
 
Join Date: Aug 2001
Location: KUL, Malaysia
Posts: 3,371
JdS will become famous soon enough
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.
 
 

Recent GIDBlogProblems with the Navy (Chiefs) by crystalattice

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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

Network Sites: GIDNetwork · GIDWebHosts · GIDSearch · Learning Journal by J de Silva, The

All times are GMT -6. The time now is 08:02.


vBulletin, Copyright © 2000 - 2010, Jelsoft Enterprises Ltd.