Union select statement

[thereaper87]

$sql=mysql_query("SELECT * FROM `buds` WHERE `level`<='$user_level' UNION SELECT * FROM `buds`, `unlocked_buds` WHERE buds.`id` = unlocked_buds.`bud_id` ORDER BY buds.`id` ASC") or die("A MySQL error has occurred.<br />Your Query: " . $sql . "<br /> Error: (" . mysql_errno() . ") " . mysql_error());

 

 

I have been trying to learn about UNION select statements. I ran the query above and got this response:

 

  Quote

Error: (1222) The used SELECT statements have a different number of columns

 

I think I know what the problem is, but not sure how to fix it.

 

There is two columns, one is "buds" which holds the flowers seeds info. The seconds is "unlocked_buds" which just links the "id" from buds to "user_id" to the user table.

 

Both buds and unlocked_buds are both 8 columns.

 

What do I need to learn?

[sunfighter]

This is a guess.

Shouldn't UNION SELECT * FROM `buds`, `unlocked_buds`

be UNION SELECT * FROM `unlocked_buds`  ?????