所以我正在将这个SQL的结果输入到一个数组中。该数组后来成为一个在输入时操作的文本框的建议列表。我希望它只返回每个姓名1次,即使该人有多个约会。目前,它返回该名称的所有约会,因此如果“Brad Robins”有5个约会,并且我开始输入“Brad”,则建议中会显示“Brad Robins” 5次,而不是只显示一次。
$sql = "SELECT DISTINCT CONCAT(clients.studentFirstName, ' ', clients.studentLastName) AS name, appointments.location, appointments.subLocation, appointments.appointmentAddress1, appointments.appointmentAddress2, appointments.appointmentCity, appointments.appointmentState, appointments.appointmentZip, appointments.startTime, appointments.endTime, appointments.date, clients.school
FROM appointments JOIN clients
ON appointments.clientID = clients.clientID
WHERE CONCAT(clients.studentFirstName, ' ', clients.studentLastName) = '".$roommate."' AND clients.school = '".$school."';";
在我看来,DISTINCT和CONCAT似乎不能很好地协同工作。