I am using this query below to search data from a table called messages where the date is nov.
$query=”SELECT * FROM messages WHERE date LIKE ‘nov%’ ORDER BY id DESC”;
I want the user to be able to choose the month he/she wants to veiw messages from using links such as November | December | January | etc…
$query=”SELECT * FROM messages WHERE date LIKE ‘$month%’ ORDER BY id DESC”;
Is this the correct query and if so how should i set up the variables and the links?
I was using this…
$month = $_get[‘month’]
and the Link was
<a href=”
But it didnt work. Im kinda confused as you can tell…