get site typename?

[skyrack_technology]

Hello - Can anyone help me with the function I should extend / create for a query to get the typename for a site from a session contact Id?
Its obviously from the sitetype table ....?

Thanks

[Tomse]

hi there

there is a generic function to return a single cell based on an ID

lookup on
http://sitracker.org/doxygen/3x/

function name is: db_read_column

this might help you.

cheers
Tomse

[skyrack_technology]

Hi Thomse - as ever, appreciate your tips!

I tried this, but I should have said this is for a form for a portal logged in user, and I'm guessing that the session doesnt know about siteid, only contactid?
So, doing:

Code: Select all

echo db_read_column('typename', $GLOBALS['dbSitetypes'], $id);

Just returns nothing ....???

[Tomse]

Hi Thomse - as ever, appreciate your tips!

I tried this, but I should have said this is for a form for a portal logged in user, and I'm guessing that the session doesnt know about siteid, only contactid?
So, doing:

Code: Select all

echo db_read_column('typename', $GLOBALS['dbSitetypes'], $id);

Just returns nothing ....???

the $id should be the id of the table afair sitetypes have 3 default (1 = unclassified, 2 = commercial and 3 = Acedemic)
so doing:

Code: Select all


function get_sitetypes($id)
{
    // hardcode ID = 3 for this example
    $id = 3;

    global $dbSiteTypes;   
    return db_read_column('typename', $dbSiteTypes, $id);
}


will return "Acedemic"

I think your error here is the lack of capital T in sitetypes.

you can find the correct naming in lib/tablenames.inc.php


cheers
Tomse