news page problem

RickyD77

i have a news page to display all the news from a db and need to be sort like this

Month 3
news3
news2
news1

Month 2
news4
news3
news2
news1

Month 1
news1

plus i have to limit the number of news in a page

thx eric

theeper

What is your question ?

RickyD77

i just dont kow how to set up my recordset to do that

thx Eric

theeper

Looks like you need a couple tables with a one-to-many relationship between them.

The first table contains the "months", the second has the "news1", "news2" etc. One entry in the month table may have many entries in the news table. Something like this ...

"month" table

id | month
1 | Jan
2 | Feb
3 | Mar

"news" table

id | month
1 | 1
2 | 1
3 | 2
4 | 3

etc ...

From this, you can see that the news table has two entries for the month of Jan. You would need to create a join in your query to pull a row from the month table and it's associated rows from the news table. Make any sense ?

christiank

Hi,

if you creating a table news with the columns date, header, text

you can select alle news with one statement in the right order:

"select year(date) y, month(date) m, date, header, text from news order by 1, 2, 3 desc;"

if you want to read one month add a where clause

"where year(date) = '$my_year' and month(date) = '$my_month'"

have fun christiank