Article Page Numbers question

[Ianedres]

With full credit to JPDeni... I modified that code to link using the query title; if not set, it will use the page id.

Code Select Expand

global $db_prefix, $scripturl, $user_info;

$query = db_query(
    "SELECT subject, id, date, shortname
     FROM {$db_prefix}tp_articles
     WHERE approved = 1
     ORDER BY date DESC
     LIMIT 10", __FILE__, __LINE__);

while ($row = mysql_fetch_assoc($query))
{
  if(empty($row['shortname'])) $row['shortname'] = $row['id'];

  echo '<a href="' . $scripturl . '?page=' . $row['shortname'] . '">' . $row['subject'] . '</a> ' . timeformat($row['date'], $user_info['time_format']) . '<br />';
}

[DonaldDasher]

You are a true gent!

[Ianedres]

Trying to earn my badge here on TP... 

Glad you're liking TP. You should be able to see the power and flexibility that it has already, plus, I like to think, a great support staff too.

Again, good luck with TP.

[DonaldDasher]

I was saying just now to the guy I run my site with what excellent and super fast support you guys offer.

[Ianedres]

Well, there are times when replies don't come so fast, as we all volunteer our time and have real-life factors to account for...

But thanks for letting others know about TP and the support you've received. 

[DonaldDasher]

My pleasure. I've learned a lot in the few weeks I've been posting here.

[JPDeni]

Oops. I guess I didn't read the second page. I changed the code over in the original topic.