[RESOLVED] SQL Query based on $_GET with if else statemetn

SeanKann

I have a table that I want to narrow down based on $_GET.

example of first url. index.php?year=2011

With that it will show everything in my database based on the date that has 2011 in it. I have a query working fine for that.

but. I want to narrow the search down so that you can click on a month and it will only show the data based on the year and the month

example index.php?year=2011&month=01

How can I put that into a if or else statement? Or should it be a if statement?

My data for date has the information is as example 2011-01-28

If I have one or the other query on/off either statement will work just not on the same page

My year query

SELECT * FROM $table where date like '$year%'

works fine by itself

My year and month query

SELECT * FROM $table where date like '$year-$month-%'

Works fine by itself.

at the top of my page I do have

$year = $_GET['year'];
$month = $_GET['year'];

Can't figure out how to get them to work together. I would like to keep everything on the same page.

TIA

dalecosp

SeanKann;11003093 wrote:
but. I want to narrow the search down so that you can click on a month and it will only show the data based on the year and the month

example index.php?year=2011&month=01

How can I put that into a if or else statement? Or should it be a if statement?

My data for date has the information is as example 2011-01-28

If I have one or the other query on/off either statement will work just not on the same page

My year query
SELECT * FROM $table where date like '$year%'
works fine by itself

My year and month query
SELECT * FROM $table where date like '$year-$month-%'
Works fine by itself.

at the top of my page I do have
$year = $_GET['year'];
$month = $_GET['year'];
Can't figure out how to get them to work together. I would like to keep everything on the same page.

TIA

I think you may need to show a little more code. I don't necessarily see your problem or understand your question. You do seem to have a problem with that variable assignment ... you're setting $month to the year parameters from the URL.

As for the other ... does this help?

if (isset ($_GET['month'])) {
   $month=$_GET['month'];
   $year=$_GET['year'];
   $sql="SELECT * FROM $table where date like '$year-$month-%'";
} else {
   $year=$_GET['year'];
   $sql="SELECT * FROM $table where date like '$year'";
}

There's probably more that could be said, but that's how you'd test to see if the month is set...

SeanKann

dalecosp;11003094 wrote:
I think you may need to show a little more code. I don't necessarily see your problem or understand your question. You do seem to have a problem with that variable assignment ... you're setting $month to the year parameters from the URL.

As for the other ... does this help?
if (isset ($_GET['month'])) {
   $month=$_GET['month'];
   $year=$_GET['year'];
   $sql="SELECT * FROM $table where date like '$year-$month-%'";
} else {
   $year=$_GET['year'];
   $sql="SELECT * FROM $table where date like '$year'";
}
There's probably more that could be said, but that's how you'd test to see if the month is set...

With using your code I got it to work

Thank you

if (isset ($_GET['month'])) {
$getmonthyear="SELECT * FROM $table where date like '$year-$month-%'";
$result=mysql_query($getmonthyear);
} else {
$getyear="SELECT * FROM $table where date like '$year%'";
$result=mysql_query($getyear);
}

dalecosp

SeanKann;11003096 wrote:
With using your code I got it to work

Thank you

You're welcome. Please take some time, or reserve some time in the future, to look at Brad's post also, as it contains good advice that you will need to take your coding skills in the direction of the "pro" level 😉