left join error

[AN-net]

what did i do wrong now>_<

Originally Posted by mysql

Invalid SQL: SELECT * FROM affiliates WHERE active='1' LEFT JOIN affiliates_types ON affiliates.type=affiliates_types.id ORDER BY sitename ASC
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN affiliates_types ON affiliates.type=affiliates_types.

[NTLDR]

There WHERE clause needs to after the LEFT JOIN clause.

[sql]
SELECT
FROM
JOINS
WHERE
GROUP BY
ORDER BY
[/sql]

[AN-net]

oh woops lol
thanks

[AN-net]

ok its not displaying whats in affiliates_types table
edit: nvm got it working