I'm trying to figure out a query to select all the `posts` that have not been reviewed yet. SO -> I want to select * from posts where reviews.project == posts.id and [there is no entry yet in reviews `by` a value]
$query="SELECT DISTINCT Project FROM Reviews";
$result=$db->query($query);
// Create an array of all IDs
$idList = arrayToCSV($arr) // create a comma seperated list
$query="SELECT Id FROM Posts WHERE Id NOT IN ($idList)";
....
$sql = "SELECT `Title`, `ID`, IF ( `Webmaster` = '3', `Programmer` AS 'User', `Webmaster` AS 'User' ) FROM `Posts` WHERE `Programmer` IS NOT NULL AND ( `Webmaster` = '3' OR `Programmer` = '3' ) AND `ID` NOT IN ('5')";
$sql = "SELECT `Title`, Posts.ID, Users.Name, IF ( `Webmaster` = '{$_SESSION['uid']}', `Programmer`, `Webmaster` ) AS 'User' FROM `Posts` JOIN `Users` ON ( IF ( `Webmaster` = '{$_SESSION['uid']}', `Programmer`, `Webmaster` ) = Users.ID ) WHERE `Programmer` IS NOT NULL AND ( `Webmaster` = '{$_SESSION['uid']}' OR `Programmer` = '{$_SESSION['uid']}' ) AND Posts.ID NOT IN ( SELECT `Project` FROM `Reviews` WHERE `By` = '{$_SESSION['uid']}' )";
I'm stoopid. I made a little mistake before, so I couldn't get that to work. But now it does.
$sql = "SELECT `Title`, Posts.ID, Users.Name, IF ( `Webmaster` = '{$_SESSION['uid']}', `Programmer`, `Webmaster` ) AS `User` FROM `Posts` JOIN `Users` ON ( `User` = Users.ID ) WHERE `Programmer` IS NOT NULL AND ( `Webmaster` = '{$_SESSION['uid']}' OR `Programmer` = '{$_SESSION['uid']}' ) AND Posts.ID NOT IN ( SELECT `Project` FROM `Reviews` WHERE `By` = '{$_SESSION['uid']}' )";
It seems unneccessary to have the two IF statements if i just give that value to `User`