Welcome Guest, Not a member yet? Register   Sign In
orderBy() function is not working when delete() function is used in query builder.
#1

PHP Code:
$sql "DELETE FROM `table_name` WHERE `feed_id` = " $feed_id " ORDER BY `date` ASC LIMIT 25"// query to be executed 



PHP Code:
$this->db->table('table_name')
->
where('feed_id'$feed_id)
->
orderBy('date''ASC')
->
limit(25)
->
delete();
echo 
$this->db->showLastQuery(); // DELETE FROM `table_name` WHERE `feed_id` = 15 LIMIT 25 


orderBy() function is not working when delete() function is used in query builder.
Reply


Messages In This Thread
orderBy() function is not working when delete() function is used in query builder. - by sustech - 05-25-2021, 06:20 AM



Theme © iAndrew 2016 - Forum software by © MyBB