best way to set concat in codeigniter? |
Hi,
I have problem with CONCAT function in mysql. this is my code PHP Code: function genitpsID() I can't set concat in codeigniter.. the output is will like this PHP Code: CONCAT('ITPS','LPAD('6', 3, '0')) My reference.. http://stackoverflow.com/questions/17893...ome-prefix Please help me..
This is me. JK not me.
try
$myquery = "CONCAT($itps, LPAD($itps_insert_id, 3, 0))"; or $myquery = "CONCAT('" . $itps . "', LPAD('" . $itps_insert_id . "', 3, 0))"; |
Welcome Guest, Not a member yet? Register Sign In |