Get data from two files

[kirke]

Hi,

I want to write such code :

// receive and save the variable as Engine ID
$EngineID = (int)$_POST['EngineType'];

dbconnect();

// In the file named dbo_J1708Vehicle, I want to get the list of
numbers in the column of iVehicleID

$sql = "SELECT iVehicleID FROM dbo_J1708Vehicle
WHERE iEngineTypeId = $EngineID";
$result = mysql_query($sql) or die();
$row = mysql_fetch_array($result)

// In drop-down box, I want to show the numbers in the file named
dbo_Vehicle, in the column of sDescriotion where iID= iVehicleID value
in prev result.

$sql2 = "SELECT * FROM dbo_Vehicle WHERE (iID) in ($row)";
$result2 = mysql_query($sql2) or die();

while( $row2 = mysql_fetch_array($result2) )
{
echo '<option
value="'.$row2['sDescription'].'">'.$row2['sDescription'].'</option>';
}


However, as you guess, it doesn't work. My another guess is.
$EngineID = (int)$_POST['EngineType'];
dbconnect();
$sql = "SELECT iVehicleID FROM dbo_J1708Vehicle
WHERE iEngineTypeId = $EngineID";
$result = mysql_query($sql) or die();
$row = mysql_fetch_array($result)

while( $row = mysql_fetch_array($result) )
{
$sql2 = "SELECT * FROM dbo_Vehicle
WHERE iID = .$row";
$result2 = mysql_query($sql2) or die();
$row2 = mysql_fetch_array($result2)
echo '<option
value="'.$row2['sDescription'].'">'.$row2['sDescription'].'</option>';
}

However, also i doesn't work. Do you guys have any idea?
Thx alot.

[kirke]

i found it. what i want to do is
require('conf.php');
$EngineID = (int)$_POST['EngineType'];

dbconnect();
$sql = "SELECT dbo_Vehicle.* FROM dbo_J1708Vehicle, dbo_Vehicle
WHERE dbo_J1708Vehicle.iEngineTypeId = $EngineID AND
dbo_J1708Vehicle.iVehicleID=dbo_Vehicle.iID";
$result = mysql_query($sql) or die();

while ($row = mysql_fetch_array($result))
{
echo '<option value="'.$row['sDescription'].'" >
'.$row['sDescription'].' </option>';
}

kirke wrote:

Hi,

I want to write such code :

// receive and save the variable as Engine ID
$EngineID = (int)$_POST['EngineType'];

dbconnect();

// In the file named dbo_J1708Vehicle, I want to get the list of
numbers in the column of iVehicleID

$sql = "SELECT iVehicleID FROM dbo_J1708Vehicle
WHERE iEngineTypeId = $EngineID";
$result = mysql_query($sql) or die();
$row = mysql_fetch_array($result)

// In drop-down box, I want to show the numbers in the file named
dbo_Vehicle, in the column of sDescriotion where iID= iVehicleID value
in prev result.

$sql2 = "SELECT * FROM dbo_Vehicle WHERE (iID) in ($row)";
$result2 = mysql_query($sql2) or die();

while( $row2 = mysql_fetch_array($result2) )
{
echo '<option
value="'.$row2['sDescription'].'">'.$row2['sDescription'].'</option>';
}


However, as you guess, it doesn't work. My another guess is.
$EngineID = (int)$_POST['EngineType'];
dbconnect();
$sql = "SELECT iVehicleID FROM dbo_J1708Vehicle
WHERE iEngineTypeId = $EngineID";
$result = mysql_query($sql) or die();
$row = mysql_fetch_array($result)

while( $row = mysql_fetch_array($result) )
{
$sql2 = "SELECT * FROM dbo_Vehicle
WHERE iID = .$row";
$result2 = mysql_query($sql2) or die();
$row2 = mysql_fetch_array($result2)
echo '<option
value="'.$row2['sDescription'].'">'.$row2['sDescription'].'</option>';
}

However, also i doesn't work. Do you guys have any idea?
Thx alot.