more precisely i want to display the last record of field of the DSprospection module in a filed of company module
can i do it like this ?
public static function display_last_vignle_record($name) {
DB::Execute('SELECT max(id),f_vignle FROM dsprospection_data_1 dsp
WHERE dsp.idclient = (select f_clientid from company_data_1 )) , array($name));
}