struck with code

[EminTugcu]

writing a article lister for mainly Joomla but im struck deeply..

i need to change the $artid dynamicly with actual article id's, which resides in  jos_content / id

it will be glad if i can get help or guidence,

thanks.

 

function makaleler($kim) {
global $database;

$sql = "SELECT jos_content.title, jos_categories.title AS section
FROM jos_content, jos_categories
WHERE jos_content.created_by = '$kim' AND jos_content.catid=jos_categories.id";

$database->setQuery( $sql );
$rows = $database->loadObjectList();

foreach ( $rows as $row ) {
$artid = ???????????
echo " <a href='index.php?option=com_content&view=article&id=$artid'>$row->title</a>/$row->section<br>";
}
}
makaleler(65);

 

 

[fenway]

Change dynamically? What does that mean?

[EminTugcu]

i mean getting the id for for each article in the "foreach" query 

[fenway]

Well, you're not getting back jos_content.id...

[adam84]

like this?

 

$sql = "SELECT jos_content.id, jos_content.title, jos_categories.title AS section
FROM jos_content, jos_categories
WHERE jos_content.created_by = '$kim' AND jos_content.catid=jos_categories.id";

$results = mysql_query( $sql );
while( $row = mysql_fetch_array( $results ) ){
   echo " <a href='index.php?option=com_content&view=article&id=".$row['id']."'>".$row['title']."</a>/".$row['section']."<br>";
}