PHP mysql multiple inner join

Question

I am trying to use two inner join as foreign key. Actually, I have transaction table and this table will be inner join customer and product. When I make SQL, it occurs error, 'You have an error in your SQL syntax'. Could you check my SQL syntax for php mysql? I cannot find error on my eye. Please help me, and thanks.

$sql = mysql_query("SELECT T.transactionId, P.product_name, P.product_price, P.stock, C.firstName, C.address, C.postCode " + 
                           "FROM transaction T " + "INNER JOIN customer C ON T.customerId = C.customerId " + 
                           "INNER JOIN product P ON T.productId = P.productId");

Gohn67 · Accepted Answer · 2012-03-03 00:26:05Z

1

It looks like you are using a plus sign instead of a period to concatenate your sql query.

answered Mar 3, 2012 at 0:26

Gohn67

10.7k2 gold badges32 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

wholee1 Over a year ago

When I delete + sign, then it OK. Can I have one more question? When I delete and want to show information, error comes, 'undefined index' about all column without transactionId. Is it any wrong syntax with INNER JOIN?

Collectives™ on Stack Overflow

PHP mysql multiple inner join

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related