Code: Select all
$result = mysql_query ("SELECT catid, id, sceneid, scene FROM products INNER JOIN products ON products.id = products_scenes.prodid WHERE catid = '$c'") or die (mysql_error());[text]Not unique table/alias: 'products'[/text]
What am I doing wrong here?
I thought you select all the fields you want, then say from what Table, and then on what fields in each table you want to join them.
Even though I have done this the way the tutorial described, "sceneid" and "scene" are not in products, but it wasn't in the table in the tutorial either, only in the 'joining' table.