[Resolved] Multitable Array Search : How to display results

[facets]

Hi All,

I've finally figured the Multitable Db search but now i'm unsure on how to echo the results.

$query = "SELECT ausapapersummary.paperCategoryId, aupapercategory.paperCategory, ausapapersummary.colloPaperName, ausapapersummary.stockId, austock.description, ausapapersummary.adhesiveId, auadhesive.description, auliner.description, ausapapersummary.linerId FROM ausapapersummary ";

$query .="LEFT JOIN aupapercategory ON ausapapersummary.paperCategoryId = aupapercategory.papercategoryId
LEFT JOIN austock ON ausapapersummary.stockId = austock.StockId          

WHERE ausapapersummary.paperCategoryId = '$paperCategoryId'";

And i'm outputting the results from the ausapapersummary like so :

while($query_data = mysql_fetch_array($result)) {
      $paperCategory = $query_data["paperCategory"];
      $colloPaperName = $query_data["colloPaperName"];
      $stockId = $query_data["stockId"];

  echo "<TR>\n";
  echo "<TD WIDTH=\"25%\" ALIGN=\"CENTER\">$paperCategory</TD>\n";
  echo "<TD WIDTH=\"25%\" ALIGN=\"CENTER\">$colloPaperName</TD>\n";
  echo "<TD WIDTH=\"25%\" ALIGN=\"CENTER\">$stockId</TD>\n";

But how does one assign ("$query_data") from another table?
ie, description from the austock table.

tia, Will.

[The_Chancer]

You can use:

Select table1.column as t1col, table2.col2 as t2col etc etc

Using AS xxx means that when they are in the array using $array['t2col'] as in the above example will give you the required array part.

[facets]

thanks for the reply.
I ended up renaming the similar fieldnames in my databse.
It made it easier to assign variables etc.

ie, dewcription from stock and ink became

stock.description and ink.description.

cheers.