[simone]

Ok i want to customise a news script, so that every post with the same date, in the mysql DB, is echo'd within the one "box". So for example, i made three posts in one day i'd want it to show like this ...

-----------------------------
10/january/04
-----------------------------
POST #3 TITLE - 9:00pm
bleh bleh bleh bleh beh etc..

POST #2 TITLE - 11:30am
bleh bleh bleh bleh beh etc..

POST #1 TITLE - 7:00am
bleh bleh bleh bleh beh etc..

------------------------------

I know it would probbaly be done using an 'if' function i just dont know how to go about it.. help anyone?

[hyjacked]

I don't think you would need an if statement, but you would definately need a loop of some sort to cycle through your results from the database.

your sql statement would be something like:
SELECT <all fields you wish to post> FROM NEWS_TABLE WHERE NEWS_DATE = '$date_to_display';

This should give you the results of all the entries for a given date, as you want. Next would be to post them on your page. something like the following should work:

PHP Code:

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {

       //format your news data

} 

hope this helps, if you need more info feel free to post back.