Love Fuel?    Donate

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.
Use a string or integer in the DB join ON method
  • ObSeSSeNObSeSSeN
    How can I write this query with the DB query builder:

    SELECT *
    FROM table1 T1
    LEFT JOIN table2 T2 ON T2.product=T1.id and T2.column = 'string'

    When I write this with the DB query builder I get an error that the 'string' column does not exist.
  • HarroHarro
    You need to encapsulate that: DB::expr('string').
Add a Comment

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories

In this Discussion