Results 1 to 11 of 11
Feb 14, 2010, 14:52 #1
- Join Date
- Aug 2009
- 0 Post(s)
- 0 Thread(s)
UNION parse error (and dynamic UNION)
I'm having trouble with a UNION.
Here is my code:
$result = mysqli_query($link, 'SELECT * FROM table_1 WHERE MATCH(column) AGAINST('$keyword1*' IN BOOLEAN MODE)
SELECT * FROM table_2 WHERE MATCH(column) AGAINST('keyword2*' IN BOOLEAN MODE)';
As a second question - is it possible to build a dynamic UNION query? I think this would be optimal but I'm not sure that this is possible.
I ask because I will need to add one more AND clause to the query above from a set of checkboxes the user can submit with this form.
Thanks in advance - hope it is clear.