[Discussion] Simple Article Index

[Ken.]

HI Ken,

I think you just need to change this part :

$request = db_query etc etc

to

$request = tpdb_query etc etc..

That works, thanks Freddy. 
http://www.ourfamilyforum.org/FamilyForum/index.php?page=216
Now I just need to move some of my articles into the proper categories. 

[Freddy]

@Lurkalot, Sorry about that, I took the code from my site, which is slightly different.  I have amended the two lines and they appear to work okay now. 

@Ken, glad to hear it

[lurkalot]

Thanks Freddy, that sorted it.  You're a star m8. 

[Freddy]

Hehe thanks

This code now has a home in the new snippets area, where the updated and correct code can be found :

http://www.tinyportal.net/index.php?topic=33208

[Ken.]

You know how sometimes you get one of those "Doh!" moments? 

If I copy&paste the code directly from Freddy's post it works just fine, but I wanted to do some editing so I placed it in Notepad++, did my edits and then pasted the resulting code to my article which promptly broke and gave me an error page. 

You likely already know the problem... Notepad++ was set to 'Normal Text', not to 'PHP'.   

[Freddy]

That's why coding is such fun 

[SN]

Hi SN, read above...

Oops Sorry Freddy, i don;t know how i missed that 

Its working great now thanks 

This is abit of a odd request, but is possible to have this in a PHP block, limited to only 5 articles for the block. without The heading area and excluding the latest 2 ( or what ever number people want to exclude ) articles by date?

The reason i ask for this is because, on my site i display 2 articles on my front page, and i have been looking for a way to list the previous 5 articles under that in a list just how you have listed it in this code.

[ZarPrime]

Wow, that really is an odd request ~ query for the last 7 but only show the first 5 of those last 7?

ZarPrime

[SN]

Wow, that really is an odd request ~ query for the last 7 but only show the first 5 of those last 7?

ZarPrime

  yeah basically lol.

don;t worry if it to much hassle...it's just something i have wanted to do for some time now. so i thought i would just put it out there

[ZarPrime]

Well, I don't know if I could figure it out but Freddy may be able to.  I was just confirming your observation that it really is an odd request.

ZarPrime