hi im new to databases

[mattm1712]

i need a code that posts the latest 10 title in the database

i have this but i know its wrong

 

 

<?php

 

include 'connect.inc';

echo "recent posts";

$recent = mysql_query("SELECT * FROM comments ORDER BY date DESC LIMIT 10");

$array = mysql_fetch_assoc($recent);

$post_title = $array['tilte'];

while($array = mysql_fetch_assoc($recent))

{

echo "$post_tilte";

 

 

}

?>

 

 

[graham23s]

Hi Matt,

 

Did you know echo "$post_tilte";

is spelt wrong?

 

cheers

 

Graham

[mattm1712]

ok cheers for that i have that bit working, but it posts the latest post 8 times instead of posting the latest 10?

[Pikachu2000]

Are there 10 records in the database table, or only 8?

[mattm1712]

theres 8 but it repeats the last 1

[Pikachu2000]

If there are only 8 records, you can't expect it to retrieve and display 10 of them. But are you saying the loop displays the same record 8 times instead of displaying all 8 of them? The query looks off to me. You are assigning the value to $post_tilte outside of the while{} loop, therefore it never changes. Try this, but note that I didn't correct the spelling of title, so you'll need to edit that if you corrected it locally.

<?php

   include 'connect.inc';
   echo "recent posts";
   $query = "SELECT tilte FROM comments ORDER BY date DESC LIMIT 10"; // separate the query, and you should only select necessary fields rather than wildcard * all
   $result = mysql_query($query); //execute the query
   while($array = mysql_fetch_assoc($result)) {
   echo $array['tilte'];
}
?>

[Lukeidiot]

If there are only 8 records, you can't expect it to retrieve and display 10 of them. But are you saying the loop displays the same record 8 times instead of displaying all 8 of them? The query looks off to me. You are assigning the value to $post_tilte outside of the while{} loop, therefore it never changes. Try this, but note that I didn't correct the spelling of title, so you'll need to edit that if you corrected it locally.

<?php

   include 'connect.inc';
   echo "recent posts";
   $query = "SELECT tilte FROM comments ORDER BY date DESC LIMIT 10"; // separate the query, and you should only select necessary fields rather than wildcard * all
   $result = mysql_query($query); //execute the query
   while($array = mysql_fetch_assoc($result)) {
   echo $array['tilte'];
}
?>

 

rename connection.inc to php or people will be able to read your database connection info