I have a calender that needs to pick up all the notes and appointments from a database.
$query_a = "SELECT id, title, description, type FROM tbl_cal WHERE the_date = '$day/$month/$year' $filter_string";
$result_a = mysql_query($query_g) or die(error_handle("Mysql: ".mysql_error()));
while ($row_a = mysql_fetch_array($result_a))
{
//Do some stuff set some variables etc...
}
The $filter_string is a a bit of the query built buy what variables are passed to it.. It will usually look like
AND type = 'note'
but i want it to pull out notes and appointments so i tried
AND type = 'note' OR type = 'appointment'
but this didnt bring back anything. So do i have to declare the date again after the "OR" ?? This brings back funny results. so what am i doing wrong??
