Joining 3 tables together.

[Namtip]

I'm trying to join the following tables together:

pro

primary key = name_id

 

1 to 1 relationship

 

user

primary key = name_id

 

1 to many relationship

 

ecomm_products

Primary key = product_code

 

the pro table doesn't have a name field in it.

 

$query = 'SELECT
        u.name_id, i.bi, i.ex, p.product_code
        FROM
        user u LEFT JOIN pro i ON u.name_id = i.name_id
	user u LEFT JOIN ecomm_products p ON u.name_id = p.product_code
        WHERE
        name = "' . mysql_real_escape_string($_SESSION['name'], $db) . '"';
    $result = mysql_query($query, $db) or die(mysql_error());

 

but I get the following error message:

"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 'user u LEFT JOIN ecomm_products p ON u.name_id = p.product_code WHERE ' at line 5"

 

Obviously I'll be trying to get past this wall myself - probably by smashing my head through the concrete - so if you want to chip in feel free to do so. 

[kickstart]

Hi

 

The bit highlighted in red is unnecessary.

 

$query = 'SELECT

        u.name_id, i.bi, i.ex, p.product_code

        FROM

        user u LEFT JOIN pro i ON u.name_id = i.name_id

user u LEFT JOIN ecomm_products p ON u.name_id = p.product_code

        WHERE

        name = "' . mysql_real_escape_string($_SESSION['name'], $db) . '"';

    $result = mysql_query($query, $db) or die(mysql_error());

 

All the best

 

Keith

[Namtip]

thanks!