Concatinatinating SQL Querys

[Ulysses_Freeman]

Maybe I"m just messing things up, but for some reason my MySQL database does not allow me to write multiple select statements in one statement such as:

SELECT Name from Name_DataBase WHERE Name_ID = (SELECT Name_ID FROM New_Name_DataBase WHERE Name = 'Ulysses')

I have to do two seperate SELECT statements.

That then creates a huge issue with PHP because from what I can tell I have to type twice as much code:

$sql = "SELECT Name_ID FROM New_Name_DataBase WHERE name = 'Ulysses' ";

$id_result = mysql_query($sql) or die(mysql_error());

where ( $id_row = mysql_fetch_row($id_result) ) {

$id = id_row[0];
}

$sql = "SELECT FName, LName FROM Name_DataBase WHERE Name_ID = '$id' ";

$name_results = mysql_query($sql) or die(mysql_error());

where ( $name_row = mysql_fetch_row($name_results)) {

$name = $name_row[0];
$name .= $name_row[1];
}
echo $id;
echo $name;

See waht I mean?

Am i compleatly off?

ulysses

[LordShryku]

MySQL doesn't support subqueries until version 4.1

[Moonglobe]

and it's not 'where', it's 'while'

[barand]

Use a join

SELECT a.Name from Name_DataBase a
INNER JOIN New_Name_DataBase b
ON a.Name_ID = b.Name_ID
WHERE b.Name = 'Ulysses')