So I have a user who has registered themselves with an email address.
This is kept in a users table.
Now this user can book a class using a calendar booking system (where they have to manually enter the email address aagain) and this data is stored in a bookings table.
Now the question is, I would like to show all the bookings the specific user has made, Selecting by their email address (can
$relevantEmail = $userRow['email'];
$get_booking = mysql_query("SELECT date, start
ON bookings.email = '$relevantEmail' " );
while($row = mysql_fetch_row($get_booking))
echo $row . " " . $row ;
Since you're not using
Users for anything, drop the join, and just use
$get_booking = mysql_query("SELECT date, start FROM bookings WHERE bookings.email = '$relevantEmail' " );
Please note that mysql_* functions are removed in PHP7 and deprecated in previous versions. Switch to PDO or mysqli, and take advantage of prepared statements and parameter binding. This will prevent you from being open to SQL injection.