Hi hope someone can help me with the following
$query3 ="SELECT * FROM narr_turnier_bambini_garde UNION SELECT * FROM narr_turnier_bambini_garde_ster WHERE id_turnier_jaar = ".$idturnierjaar." order by rang, meestepunten DESC";
The WHERE clause dosn't work what i want
because it give me all the rows from both tables and column id_turnier_jaar is an id number and it is more then ones it could be shall we say 5 times with an id number 1 and some where else is the id numer about 7 times with the id number 2.
$idturnierjaar is the id number from POST from a form.
Thanks in advice JOHN