Here is my search query, which is putting out an argument error.
What do I need to do to correct it. Basically I need to put both of these tables together and pull out the next 5 events within the two tables by the start
date. You will also notice that the last field in each table is different from one another.
$CEsql = mysql_query("
SELECT id, title, start, end, allDay
FROM calendar
WHERE mem_id='$logOptions_id'
AND start >= DATE_SUB( CURDATE( ) ,INTERVAL 0 MONTH )
UNION ALL
SELECT id, title, start, end, allDay
FROM team_calendar
WHERE team_id IN ($team_array)
AND start >= DATE_SUB( CURDATE( ) ,INTERVAL 0 MONTH )
ORDER BY start ASC LIMIT 5");
I am using MYSQL 5.0 and PHP.
Update
mysql_error
displays:
1267: Illegal mix of collations for operation 'UNION'