[Resolved] Not getting data from database.

[harlequeen]

I am very new to this. I am trying to work through a tutorial, but cannot get the script to work.

I have a small database from which I want to extract headlines which have the status 'C'.

I cannot get the headlines to display. The code I am using is below. I inserted an echo statement so that I could see what was being actioned.

$query = @mysql_query("SELECT * FROM news WHERE news.status='C' ORDER BY headline asc");

$result = @mysql_query($query);
echo "Hello again";
while ($row = mysql_fetch_array($result)) {


echo "<a href=editnewsitem.php?id=".$row['id'].">" .$row['headline']."</a><br>";
} 

As I understand it, $row will fetch each iincidence of the result of my query. In this case there should be 3 headlines returned.

I am sorry if this is very basic, but I cannot seem to get any output after the 'Hello again' echo.

Cheers
Harlequeen

[devinemke]

// i'm assuming you are already connected to the database

$result = mysql_query("SELECT * FROM news WHERE status = 'C' ORDER BY headline") or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	echo '<a href="editnewsitem.php?id=' . $row['id'] . '">' . $row['headline'] . '</a><br>';
}

[harlequeen]

Thanks for your help. That code didn't work either, but I was able to fiddle around using the ideas that you gave and echoing statements to see what was happening.

Thanks again.
Harlequeen