aql/dd

From SkyPHP

aql | aql dd |

Contents 1 Description 2 Parameters 3 Return Values 4 Examples 4.1 Display a dropdown of campaigns 5 See Also 6 Known Bugs & Issues

Description

dd ( string $aql, array $dropdown )

Parameters

aql - aql statement to retrieve

dropdown - array of select attributes

Return Values

returns a HTML <select>

Examples

Display a dropdown of campaigns

   $aql = "ct_campaign {
		name
		where archive=0
	        and year is not null
		and ct_promoter_id =1
		order by year desc, name asc
   }";
   $dropdown = array(
		'select_name' => 'ct_campaign_ide',
		'value_field' => 'ct_campaign_ide',
		'option_field' => 'name',
		'selected_value' => $_GET['ct_campaign_ide'],
		'null_option' => '- Select Campaign -',
		'onchange' => 'this.form.submit()'
   );
   aql::dd($aql,$dropdown);

See Also

• aql class

Known Bugs & Issues

n/a