PHP get_array_by_query Examples

Example #1

File: Release.class.php Project: BackupTheBerlios/igoan-svn

 function list_categories()
 {
     return get_array_by_query('SELECT id_cat FROM ' . DB_PREF . '_belongsto WHERE id_rel=\'' . int($this->get_id_rel()) . '\'');
 }

Example #2

File: User.class.php Project: BackupTheBerlios/igoan

 function list_releases()
 {
     return get_array_by_query('SELECT id_rel FROM authors WHERE id_user=\'' . int($this->get_id_user()) . '\'');
 }

Example #3

File: Platform.class.php Project: BackupTheBerlios/igoan-svn

function platform_list()
{
    return get_array_by_query("SELECT id_pf,name_pf FROM platforms ORDER BY name_pf");
}

Example #4

File: Project.class.php Project: BackupTheBerlios/igoan-svn

 function list_branches($id_branch = 0)
 {
     return get_array_by_query('SELECT id_branch FROM branches WHERE id_prj=\'' . int($this->get_id_prj()) . '\' AND id_branch<>' . int($id_branch));
 }

Example #5

File: License.class.php Project: BackupTheBerlios/igoan

function license_list()
{
    return get_array_by_query('SELECT id_lic,name_lic,terms FROM licenses ORDER BY name_lic');
}

Example #6

File: Branch.class.php Project: BackupTheBerlios/igoan-svn

 function list_releases($except_rel = 0)
 {
     return get_array_by_query('SELECT id_rel FROM releases WHERE id_branch=\'' . int($this->get_id_branch()) . '\' AND id_rel<>' . int($except_rel) . ' ORDER BY date_rel DESC');
 }

Example #7

File: Language.class.php Project: BackupTheBerlios/igoan-svn

function language_list()
{
    return get_array_by_query('SELECT id_lang,name_lang FROM ' . DB_PREF . '_languages ORDER BY name_lang');
}

Example #8

File: Category.class.php Project: BackupTheBerlios/igoan

function category_list_all()
{
    return get_array_by_query('SELECT id_cat,name_cat,index,parent FROM categories ORDER BY index');
}

Example #9

File: Platform.class.php Project: BackupTheBerlios/igoan-svn

function platform_list()
{
    return get_array_by_query('SELECT id_pf,name_pf FROM ' . DB_PREF . '_platforms ORDER BY name_pf');
}