// ******* Populate Client Update Form from DB  *********************************
add_filter("gform_pre_render_4", populate_lead);
function populate_lead($form){

		//Get LeadID
		if(empty($_GET["lid"]))
    		$lead_id = 0;
		else
    		$lead_id = $_GET["lid"];

	//	echo $lead_id;

		//Get entry data for LeadID
		$entries = get_client_entry(2,$lead_id);

		//Adding initial blank value.
	    $field_data[] = array("field_number" => "", "value" => "");

	    //Adding fields to the array
		foreach($entries as $entry)
		 	$field_data[] = array("field_number" => $entry->field_number, "value" => $entry->value);

		//Populate fields.
	    foreach($form["fields"] as &$field) {
			foreach($field_data as $key => $value) {
 	        	if($field["id"] == $key){
	            	$field["value"] = $value;
	        	}
			}
		}

	   return $form;
}
function get_client_entry($form_id,$lid) {
    global $wpdb;

    $table_name = $wpdb->prefix . "rg_lead_detail";

    $results = $wpdb->get_results($wpdb->prepare("
        SELECT *
        FROM $table_name ld
        WHERE ld.form_id = %d and ld.lead_id = %d order by ld.field_number",
        $form_id, $lid));

    return $results;
}