CodeIgniter: Get value of 2 tables using join, using first table column value
I have 2 tables. I want to get ProductID (primary key) from tblProduct using ProductUrl value. Then tblProduct.ProductID should join with tblImage.ProductID and give me only that one value of ImageUrl where ImageThumb = 1.
At the end I want that final 1 row of tblProduct all details and tblImage url.
Subquery Condition In Codeigniter 4
Any idea how to convert query below into Codeigniter?
I got some error in pagination in ci3 below i have attached the error
this is the error
MySql field name have dot . Data not insert
I have OrderList table in mysql. there is field name paymentInfo.Prepaid.razorpayOrderId. I want to insert the data using codeigniter. But I’m getting below the error
Sum with join returns wrong data
I have 3 tables in the database and I’m trying to return summation from 2 columns regarding a criteria.