[SOLVED] mySQL JOIN Statement

[a1amattyj]

Hello,

 

Two tables, multi_admins and multi_permissions, trying to select a single row from each table where the ID is specified.

 

SELECT * FROM `multi_admins` 
		  INNER JOIN `multi_permissions` 
		  ON `multi_admins.id` = `multi_permissions.admin_id`
		  WHERE `multi_admins.id` = '".clean_up($_SESSION['id'])."

 

Wondering if anyone can help, first stab at a join statement.

 

Thanks!

[toplay]

Watch where you put the backtick marks.

 

$sql = "SELECT * FROM `multi_admins`

  INNER JOIN `multi_permissions`

  ON `multi_admins`.id = `multi_permissions`.admin_id

  WHERE `multi_admins`.id = '" . clean_up($_SESSION['id']) . "'";

[a1amattyj]

Watch where you put the backtick marks.

 

$sql = "SELECT * FROM `multi_admins`

  INNER JOIN `multi_permissions`

  ON `multi_admins`.id = `multi_permissions`.admin_id

  WHERE `multi_admins`.id = '" . clean_up($_SESSION['id']) . "'";

 

Thanks, works perfectly!