View data in a mysql PHP week range

Question

I am creating a code that will show the tidal table, I have a table with the following fields: Date - Time - Tideheight

It is already all filled, I need to make a query and select the data of the week, as the day, the hour and the height of the tide.

How it works in the navy website.

I wrote the code below, I need it to display the current week, or an interval of 7 days from today forward.

//semana atual
$data = date('W');

// cria a instrução SQL que vai selecionar os dados 
$query = mysql_query("SELECT * FROM tidedata WHERE WEEK(date) = '$data'"); 

echo "Tide for week:<br/>";

while ($array = mysql_fetch_assoc($query)) {

    echo $array["date"]." ".$array["time"]." ".$array["tideheight"]."<br/>";

} 

How do I display the table data in the interval of a week, displaying the day, time and height of the tide?

I solved this problem as follows:

//semana atual
$semana = date('W');
$ano = date('Y');

// cria a instrução SQL que vai selecionar os dados 
$query = mysql_query("SELECT * FROM tidedata WHERE WEEK(date) = '$semana' AND YEAR(date) = '$ano'"); 

echo "Tide for week:<br/>";

while ($array = mysql_fetch_assoc($query)) {

        echo $array["date"]." ".$array["time"]." ".$array["tideheight"]."<br/>";

}

If someone has another solution can post below.