Jump to content

[SOLVED] how?


tritus

Recommended Posts

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>";

    }

 

?>

Link to comment
https://forums.phpfreaks.com/topic/68261-solved-how/
Share on other sites

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
?>

Link to comment
https://forums.phpfreaks.com/topic/68261-solved-how/#findComment-343182
Share on other sites

<?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']  " 

;
   }

?> 

 

Link to comment
https://forums.phpfreaks.com/topic/68261-solved-how/#findComment-343186
Share on other sites

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
?>

Link to comment
https://forums.phpfreaks.com/topic/68261-solved-how/#findComment-343188
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.