Double Query

[monkeypaw201]

So, i have this code again, and i have a previous query that pulls soething from the database and provides an ID relative to another database, and then i need to query again from the database WHERE that ID matches the table. THEN i need to take THAT ID and re-query for a final match.

 

<?php 
$con = mysql_connect("localhost","user","pass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }mysql_select_db("database", $con);
  $result = mysql_query("SELECT * FROM domiciles WHERE id = '$row_Pilot[hub]'");
  while($row = mysql_fetch_array($result))
  {
  $airport = $row['airport'];
  }
  
  $air = mysql_connect("localhost","user","pass");
if (!$air)
  {
  die('Could not connect: ' . mysql_error());
  }mysql_select_db("database", $air);
  $result = mysql_query("SELECT * FROM airs WHERE id = '$airport'");
  while($row = mysql_fetch_array($result))
  {
  echo = $row_air['city'];
  }mysql_close($air);
mysql_close($con);
  
		 ?>

[revraz]

Sounds like you should just use the MySQL JOIN if the table all relate.

[monkeypaw201]

Sounds like you should just use the MySQL JOIN if the table all relate.

 

1. Don't know that function or what it does

2. I need them all seperate for functunality on the rest of the site

[rhodesa]

You don't need to connect twice, as long as it is the same database.

 

And, you just need to store your result into different variables and you can have as many queries going as you want:

 

<?php 
$con = mysql_connect("localhost","user","pass")
  or die('Could not connect: ' . mysql_error());
mysql_select_db("database", $con)
  or die('Could not select db: ' . mysql_error());
$result1 = mysql_query("SELECT `airport` FROM `domiciles` WHERE `id` = '{$row_Pilot['hub']}'");
while($domicileRow = mysql_fetch_array($result1)){
  $result2 = mysql_query("SELECT * FROM `airs` WHERE `id` = '{$domicileRow['airport']}'");
  while($airRow = mysql_fetch_array($result2)){
    echo = $airRow['city'];
  }
}
?>

[craygo]

$sql = "SELECT * FROM domiciles JOIN airs ON domiciles.airport = airs.id WHERE domiciles.id = '$pilothub'";

 

You should have $pilothub = some variable

 

Ray

[monkeypaw201]

Thanks rhodesa;

 

Unfontunately it didnt help i still get a blank page...

[revraz]

Turn on error reporting.

[monkeypaw201]

if it helps when i do this, i works (it echos the right ID)

 

<?php 
$con = mysql_connect("localhost","user","pass");
if (!$con)
 {
 die('Could not connect: ' . mysql_error());
 }
 mysql_select_db("database", $con);
 $result = mysql_query("SELECT * FROM domiciles WHERE id = '$row_Pilot[hub]'");
 while($row = mysql_fetch_array($result))
 {
 $airport = $row_con['airport'];
 }
 /**
$air = mysql_connect("localhost","user","pass");
if (!$air)
 {
 die('Could not connect: ' . mysql_error());
 }mysql_select_db("database", $air);
 $result = mysql_query("SELECT * FROM airports WHERE id = '$airport'");
 while($row = mysql_fetch_array($result))
 {
 echo = $row_air['city'];
 }
mysql_close($air);  */
mysql_close($con);
 
		 ?>

 

Turn on error reporting.

 

:/ Never learned how...

[rhodesa]

if it helps when i do this, i works (it echos the right ID)

 

<?php 
$con = mysql_connect("localhost","user","pass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
  mysql_select_db("database", $con);
  $result = mysql_query("SELECT * FROM domiciles WHERE id = '$row_Pilot[hub]'");
  while($row = mysql_fetch_array($result))
  {
  $airport = $row_con['airport'];
  }
  /**
$air = mysql_connect("localhost","user","pass");
if (!$air)
  {
  die('Could not connect: ' . mysql_error());
  }mysql_select_db("database", $air);
  $result = mysql_query("SELECT * FROM airports WHERE id = '$airport'");
  while($row = mysql_fetch_array($result))
  {
  echo = $row_air['city'];
  }
mysql_close($air);  */
mysql_close($con);
  
		 ?>

 

Turn on error reporting.

 

:/ Never learned how...

 

What do you mean it echos the right thing? You aren't echoing anything.

[craygo]

where is $row_Pilot[hub] coming from??

 

try this

<?php
$con = mysql_connect("localhost","user","pass")
  or die('Could not connect: ' . mysql_error());
mysql_select_db("database", $con)
  or die('Could not select db: ' . mysql_error());
$result1 = "SELECT airs.city AS city FROM domiciles JOIN airs ON domiciles.airport = airs.id WHERE domiciles.id = '{$row_Pilot['hub']}'";
$res =  mysql_query($result1) or die(mysql_error());
  while($airRow = mysql_fetch_array($result1)){
    echo $airRow['city'];
  }
?>

 

Ray

[revraz]

Are those tables on the same database?  If so, why open two connections anyways?

[monkeypaw201]

rhodesa, my mistake, there should be an echo here:

$airport = $row_con['airport']; echo $airport;

i forgot to copy/paste it..

 

---------

 

craygo , the $row_Pilot[hub] is coming from a previous query higher up on the page..

 

---------

 

revraz, just because i'm more comfortable troubleshooting it.. i have had little experience merging them together, and more the more complex ones, i go back to the basics..

 

-------

EDIT:: Would it help if i provide the whole page source?

[monkeypaw201]

FIXED

 

Ok, i kept messing with it and came out with this (Yes, It WORKS)

 

<?php 
$con = mysql_connect("localhost","user","pass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
  mysql_select_db("database", $con);
  $result = mysql_query("SELECT * FROM domiciles WHERE id = '$row_Pilot[hub]'");
  while($row_con = mysql_fetch_array($result))
  {
  $airport = $row_con['airport'];
  }
  mysql_close($con);
?>
<?php 
$con = mysql_connect("localhost","user","pass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
  mysql_select_db("database", $con);
  $result = mysql_query("SELECT * FROM airports WHERE id = '$airport'");
  while($row_con = mysql_fetch_array($result))
  {
  $city = $row_con['city'];
  echo $city;
  }
  mysql_close($con);
?>