June 18th, 2000, 12:23 PM
I want to execute a composed request, ie :
$result = mysql_query("SELECT NomDem FROM reversation WHERE datrep= (SELECT MAX(datrep) FROM Représentation WHERE DatRep<='31-12-99')");
but PHP doesn't seems to like the second SELECT...
Any solution ?
June 18th, 2000, 06:04 PM
oh.. hehe i think i answered on the php board.. oops..
read there first.. =)
June 21st, 2000, 12:53 AM
U can't give (sub-selects) or (sub-queries) in MySql, instead of sub-selects U can use
Joins . Sub-selects are possible in MySql 3.22.24 version ,yet to be released.