SQL query not working with PHP- Help please!!

[jayelarex]

I am trying to return results for a DB with the month of 3 ($month ) and between a certain time frame ($startweek and $endweek).

Seems like its pretty easy but my query is not working..

Here is the begining of the code (the rest i can figure out.)

-------------------------------------------------------------------

<?php

$month = 3;
$startweek = 7;
$endweek = 14;


$sql = "SELECT * FROM datetest where month='$month' ORDER BY date LIMIT $startweek, $endweek";


-----------------------------------------------------

Thanks in advance.