Multiple Query Echoing

[rayishu]

Ok im sorry to ask this but it is a huuge problem that i dont know how to start ok basicly all i want to do is just get information from this table and print the 5 most recent additions to the database heres the database structure in SQL

CREATE TABLE `news` (
  `id` int(6) NOT NULL auto_increment,
  `event` varchar(255) collate latin1_general_ci NOT NULL,
  `date` varchar(20) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)

i have this table in my page that i want to print the 5 most recent ones in. also how do i loop through each field if it has mutliple elements thats where im really stuck...

like if i have $something['userid'] and it has like more than one value because theres more than 1 row selected from that colum how do i echo() each indivitdual one?

[thorpe]

A simple example....

$sql = "SELECT id,event,`date` FROM news ORDER BY `date` DESC LIMIT 5";
if ($result = mysql_query($sql)) {
  while ($row = mysql_fetch_assoc($result)) {
    echo $row['id']."<br />";
    echo $row['event']."<br />";
    echo $row['date']."<br />";
  }
}

Your second question makes little sense.

[rayishu]

no thax man u answered all of my questions