php mysql using nested query

Question

I am trying to find if two runners have ever ran in the same race. The two runners are Peter Smith and Diane Peters.

$resultRaceType = mysqli_query($db,"SELECT  DISTINCT date,time FROM results where runner = 'Peter, Smith' ");   
while($row = mysqli_fetch_array( $resultRaceType )) 
{
    $resultRaceType1 = mysqli_query($db,"SELECT  * FROM results where date = ' " . $row['date'] . " ' and time = ' " . $row['time'] . " ' and runner = 'Diane, Peters'");   
    while($row1 = mysqli_fetch_array( $resultRaceType1 )) 
    {
        echo "<tr >";   
        echo "<td>"; 
        echo $row1['date'];
        echo " - " . $row1['time'];
        echo "</td>";   
        echo "<tr>";    
    }    
}

The above code works, but only if I limit the first select to LIMIT 50. So I can see that it is timing out. My table has over 100K rows. I know I am doing something wrong but cant see what it is. Thanks for any help you guy's can give me.

Answer 1

Try:

SELECT a.date, a.time FROM results a
    JOIN results b ON (a.date = b.date AND a.time = b.time)
    WHERE a.runner='Peter, Smith' AND b.runner='Diane, Peters';