Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

Umarshah's avatar

laravel query builder error

SELECT id,account_name,parent_id FROM (SELECT id,account_name,parent_id, CASE WHEN id = 1 THEN @idlist := CONCAT(id) WHEN FIND_IN_SET(parent_id,@idlist) THEN @idlist := CONCAT(@idlist,',',id) END as checkId FROM chart_of_account ORDER BY id ASC) as T WHERE checkId IS NOT NULL

When i run this query in mysql i work fine result fetch perfect

but i run it in laravel like this

$accountId = DB::select('SELECT id,account_name,parent_id FROM (SELECT id,account_name,parent_id, CASE WHEN id = '.$account_id.' THEN @idlist := CONCAT(id) WHEN FIND_IN_SET(parent_id,@idlist) THEN @idlist := CONCAT(@idlist,',',id) END as checkId FROM chart_of_account ORDER BY id ASC) as T WHERE checkId IS NOT NULL');

give error

Argument 1 passed to Illuminate\Database\Connection::prepareBindings() must be of the type array, string given, plz help thanx in advance

0 likes
2 replies

Please or to participate in this conversation.