Advice on a table

[jbradly]

I want to create a table to which 3 different users will post data. The data is just message/news data and each user will only need to post data to one field. So far I have a table with the fields:
ID, Message, Daily_Announcement, and News

I want to extract the data posted into each field and display it on a corresponding html page. I have the following code to extract and display the data but it displays everything input into the table and I want to be able to display just the most recent entry from each of the fields. What would be the best way to set up the table and what am I missing to just extract the most recent posting?
<?php
$db = mysqli_connect("localhost", "", "","db-jvadmin");
if (!$db)
{
die('Could not connect: ' . mysqli_error());
}

$query = "SELECT * FROM Announcements";

$result = mysqli_query($db,$query);

while($row = mysqli_fetch_array($result))
{
echo $row[Message'];
}
mysqli_close($db);
?>

[TheServant]

Syntax error: echo $row['Message']; (you had: echo $row[Message'];)

I will have to think about how to get the most recent as I am still unsure about how the table is set out. Try fix that syntax error and see if it no longer returns all the row data.

Also post your code in the correct tags! Just above where you post (where the Bold and Italic options are) there are code tags (CODE, PHP, HTML, etc).

[Markus]

Use a 'limit' clause.

[php]
<?php
$db = mysqli_connect("localhost", "", "","db-jvadmin");
if (!$db)
{
die('Could not connect: ' . mysqli_error());
}

$query = "SELECT `Message`,`Daily_Announcement`,`News` FROM Announcements LIMIT 1";

$result = mysqli_query($db,$query);

while($row = mysqli_fetch_array($result))
{
echo "{$row['Message']} - {$row['Daily_Announcement']} - {$row['News']}";
}
mysqli_close($db);
?>
[/php]
regards.