[SOLVED] how?

[tritus]

i am making a news script for my site and i want to only pull the latest entry into the database... how do i do that?

 

my code:

 

<?php

 

    mysql_connect("localhost", "$db_user", "$dbpass");

    mysql_select_db(tritusco_news);

    $sql = mysql_query("SELECT * FROM news");

    while($result = mysql_fetch_array($sql)) {

    echo " <b>Date:</b> " .$result["date"] . "<br>";

echo " <b>Subject:</b> " .$result["subject"] . "<br>";

    echo " <b>Body:</b> " .$result["body"] . " <br><br>----------------<br><br>";

    }

 

?>

[GingerRobot]

Two options.

 

1.) Add a limit statement to your query:

 

$sql = mysql_query("SELECT * FROM news LIMIT 1");

 

2.) Dont use a while loop. Instead of:

 

<?php
while($result = mysql_fetch_array($sql)) {
//code here
}
?>

 

Just do:

 

<?php
$result = mysql_fetch_array($sql);
//code here
?>

[darkfreaks]

<?php

   mysql_connect("localhost", "$db_user", "$dbpass");
   mysql_select_db(tritusco_news);
   $sql = mysql_query("SELECT * FROM news");
   $result = mysql_fetch_array($sql)) {
   echo " Date:$result['date']"
;
  echo " Subject:$result['subject'] . "
;
   echo " Body: $result['body']  " 

;
   }

?> 

 

[tritus]

this grabs one, but it isnt the latest entry

 

 

Two options.

 

1.) Add a limit statement to your query:

 

$sql = mysql_query("SELECT * FROM news LIMIT 1");

 

2.) Dont use a while loop. Instead of:

 

<?php
while($result = mysql_fetch_array($sql)) {
//code here
}
?>

 

Just do:

 

<?php
$result = mysql_fetch_array($sql);
//code here
?>

[GingerRobot]

Forgot to add, you'll need an order by clause in your query. You could use the date field for that

 

$sql = mysql_query("SELECT * FROM news  ORDER BY date DESC LIMIT 1");

[tritus]

thanks for the help works!!!