Echoing info by ID

[blink359]

In a table i have the collums ID and text the id is a number. i want to echo on my main page the latest 5 but induvidually so you will have

Latest one

next latest

next latest

etc

 

If you can help that would be great

Thanks

Blink359

[gevans]

Have you attmepted this, used php/mysql before? Some code will help. If you haven't tried yet I recommend you do as no-one is going to write this for you. Though it is a very simple application, just looking at the mysql_query syntax on the php.net website will probably sort this out for you.

[phpSensei]

Have you attmepted this, used php/mysql before? Some code will help. If you haven't tried yet I recommend you do as no-one is going to write this for you. Though it is a very simple application, just looking at the mysql_query syntax on the php.net website will probably sort this out for you.

 

What he said, except the part where no one will write it for you. I am feeling generous.

 

here

 

<?php

$query = @mysql_query("SELECt * FROM `table` ORDER BY `id` DESC LIMIT 5");

if($query){

  while($row=mysql_fetch_array($query)){


   $row['text'] . '<br>';

  }


}

?>

[neogemima]

Check out a tutorial, like http://www.tizag.com/phpT/

 

[gevans]

What he said, except the part where no one will write it for you. I am feeling generous.

 

here

 

<?php

$query = @mysql_query("SELECt * FROM `table` ORDER BY `id` DESC LIMIT 5");

if($query){

  while($row=mysql_fetch_array($query)){


   $row['text'] . '<br>';

  }


}

?>

 

I was wrong there are some people here that will write it for you, but I wouldn't supress errors using the @ symbol.

 

@mysql_query("SELECt * FROM `table` ORDER BY `id` DESC LIMIT 5");

 

You want to know if there's an error!

 

<?php
$query = mysql_query("SELECT * FROM `table` ORDER BY `id` DESC LIMIT 5") or die("Error: ".mysql_error());