Pulling Latest 6 Updates

[jaZon]

I'm working on this news script that will allow a person to, of course, submit news to the site to be auto updated. On the form there will be a place for Title, Body, Month, Year and maybe a few other things. My question is how would I go about just pulling the latest 6 topics to display. I was thinking of doing an auto dating command or something, but that will not work as these news articles are pre-prepared and an older one may be inserted after a new one. Anyone have any ideas?

[leatherback]

Hi,

How about adding a date-field which is not a timestamp, but which you set yourself (WriteDate). There you can put your own date (The date at which the article was written).

When querying you query the database, sorted on WriteDate, limiting the results to the last 6.

so the query would be something linke:

select * from database order by WriteDate desc limit 0, 6

J.

[jaZon]

Awesome, thanks a bunch. I've got that working fine now. 😃 Now my problem is trying to provide links to each one seperately. As you can see I'm pretty new to this. I was thinking of doing an if else and if the writedate is set in URL or something of that nature having it display, but I can't figure out how to go about that either! :mad:

[jaZon]

This is what I have so far. What I want to do is make the Month and the year link to a formatted page and drop in the rest of the variables from that row.

Here is a link to what it looks like thus far:

http://www.thomasdrug.com/test/headers.php

<?

include("config.php");
$db = mysql_connect("$dbhost","$dbuser","$dbpw"); 
mysql_select_db ($dbase) or die ("Cannot connect to database"); 

$query = "SELECT * FROM $table ORDER BY date DESC LIMIT $number"; 
$result1 = mysql_query($query);



while($tab=mysql_fetch_array($result1))
{
$id=$tab["newsid"]; 
$title=$tab["title"]; 
$body=$tab["body"]; 
$excerpt=$tab["excerpt"];
$month=$tab["month"];
$year=$tab["year"];
$date=$tab["date"];
$name=$tab["name"];



print("<table class=inbar width=100% border=0 cellspacing=0 cellpadding=6>
         <tr>
           <td>

       $month, $year
	   <BR>
	   &nbsp;&nbsp;<i>$title</i>




       </td>
     </tr>
   </table>




 ");
}


?>

[jaZon]

anyone? When the link is clicked on the particular news feature I just want to pull the variables out of that row and display them in a seperate preformatted page.

[TalonFinsky]

I did something similar and used an auto_increment field as an id number. When I wanted to display the latest x number of entries, I would sort by newsid desc.

On the link to the news article itself, you could do something like:

<a href="page.php?newsid=4">Click here to view this entry</a>

And then just use the $newsid variable passed to the new page (page.php) in a select:

$query = "select * from TABLENAME where newsid = '".$newsid."'";
$result = mysql_query($query);

[jaZon]

I totally forgot to post saying I had figured it out! Thanks for the reply. That's exactly what i wound up doing at like 3am this morning when I couldn't sleep. 😉