I know this must be a simple question... but I can't seem to figure it out.
I am trying to select all rows were the column "category" is either '$sort' or 'all'. I also want it to sort the day too.
I put down this:
However, the result from that makes it seem like it didn't even consider the "category = " part.
$sql = "select * from calendar where date LIKE ('%$year-$month-$day%')&& category = ('all' OR '$sort');";
Any help would be great
$sql = "select * from calendar where date LIKE ('%$year-$month-$day%') && (category='all' || category='$sort')";
Oh, hehe. I thought it was something simple like that. :o
Thanks for the help :) :)