joomla query to get sectionid

trying to get something in content.php

[David_M]

I'm trying to get the sectionid when the file content.php runs (com_content) in joomla 1.0x.

$uid=$id;
$query = "SELECT *"
. "\n FROM #__content"
. "\n WHERE id = " . (int) $uid
;
$database->setQuery( $query );
$row = NULL;
$row = $database->loadObjectList();
$mysectionid =$row->sectionid;

Any ideas why its not giving me the sectionid?

[Habtom]

Try echoing your query echo $query; and see if you have got the query right. Perhaps that will give you a hint if there is a problem with the query.

[David_M]

Got it.

$query = 'SELECT sectionid FROM #__content WHERE id = ' . $id;
$database->setQuery( $query );
$mysectionid = $database->loadResult();