CODEWITHSUNDEEP
phphtmlmysqlapachecodeigniter
TotalNewbie
TotalNewbie

Reputation: 1024

Codeigniter Chained Queries Issue

I am currently using CI to develop a small application - I am running the majority of queries using a query chain, but I am running into an issue inserting spaces using the CONCAT function as seen below:

$this->db->select('P.PizzaID, P.PizzaName AS Pizza Name, S.SupplierCode AS Supplier Code, P.CookingTime AS Cooking Time, CONCAT(S.SupplierTitle, ' ', S.SupplierFirstName, ' ', S.SupplierLastName) AS Name')
         ->from('Pizzas P, Supplier S')
         ->where('P.CookingTime', 30)
         ->get();

The query errors as I want to insert spaces in between getting each value. What am I doing wrong?

Upvotes: 0

Views: 70

Answers (1)

Sam Dufel
Sam Dufel

Reputation: 17598

If you want to include quotes inside a php string, you need to either use a different style quote than the enclosing quotes of the string, or escape the inner quotes with a backslash.

Each of your single quotes is actually opening and closing the outer string, causing a syntax error.

Upvotes: 2

Related Questions