Joining two tables

[thereaper87]

Hello there,

 

decided to try to have a joined table query, running into a couple of problems.

Here is the query:

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

 

Which gives the error:

A MySQL error has occurred.

Your Query:

Error: (1054) Unknown column 'id.buds' in 'where clause'

 

The two tables are 'buds' and 'unlocked_buds'

 

 

Not really sure what to change, I have been following this tutorial http://www.sqltraining.org/selecting+data+from+multiple+tables/, but really is not helping that much.

 

 

What exactly does that mean? What really is happening?

[php-lover]

try this

 

 

$sql = 'SELECT b.* FROM buds AS b JOIN unlocked_buds AS u ON b.bud_id = u.bud_id ORDER BY b.bud_id ASC';

$result = mysql_query($sql) or die(mysql_error());