How can I use insert into with where clause

[armcar]

Hi

I have this script that works directly (mySql)

INSERT INTO at_crc_tratamento_manual (dia, nif, tribunal, processo, citacao, certidao, juizo, nome, sf) SELECT dia,nif,tribunal,processo,citacao,certidao,juizo,nome,sf from at_crc_reclamacao_de_creditos WHERE processo = '441/12.0TBTND . 1';

How can I use db Class with it. Something like that, but just find the correct terms $id = $db->insert ( at_crc_tratamento_manual , $array )

[Brecht272727]

You can also use this:

$db->rawQuery( 'INSERT INTO at_crc_tratamento_manual (dia, nif, tribunal, processo, citacao, certidao, juizo, nome, sf) SELECT dia,nif,tribunal,processo,citacao,certidao,juizo,nome,sf from at_crc_reclamacao_de_creditos WHERE processo = '441/12.0TBTND . 1' )

[armcar]

Ok! Thank You I have in mind something like that you (thanks) give:

$wSQL = "SELECT * FROM xxx WHERE yyy"; $data = $db->query( $wSQL );

It should return the same, but I realy didn't found something more like tradicional queries (using $db of course) $resposta['data'] = $db ->where('processo', $p ) ->get(DB_PRE.'crc_tratamento_manual tbl', null, 'DISTINCT tbl.*'); Understand? But the important is have a way, a solution, and i got it. Thank you so much

In Time Obrigado desde Portugal - Viseu

[Brecht272727]

Hi, you're welcome but it is $data = $db->rawQuery( $wSQL );

But for a better solution i don't know for your query. Maybe @ThingEngineer you can help here?

[armcar]

Of course. My mistake. Thank you