Joins doing crazy things.
Posted: Sat Oct 29, 2005 12:00 pm
Code: Select all
$sql = "SELECT * FROM `Reviews` WHERE `For` = '{$_GET['q']}'";
$mySQL->execSQL( $sql );
while ( $rev = $mySQL->nextObject() ) {
$sql = "SELECT `Title` FROM `Posts` WHERE `ID` = '{$rev->Project}'";
$project = $mySQL->getField( $sql, "Title" );
$sql = "SELECT `Name` FROM `Users` WHERE `ID` = '{$rev->By}'";
$name = $mySQL->getField( $sql, "Name" );
// print_r( $rev ); echo $project; echo $name;
}Code: Select all
$sql = "SELECT *, Users.Name, Posts.Title FROM `Reviews` JOIN `Users` ON ( Users.ID = Reviews.By ) JOIN `Posts` ON ( Posts.ID = Reviews.Project ) WHERE Reviews.For = 'X'";MySQL ver 4.1.14