Hi, I have just found out that I can't use nested queries with MySQL so could someone tell me how i can transform the following query for use with MySQL? SELECT * FROM Allocations WHERE (SELECT Project_ID FROM Project WHERE Project_Name = $_POST[project_name]) thanks for your help -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php