Nifty

I am reasonably new to PHP. Had to convert a heap of MySQL to ODBC. It works but drops the last (newest) row from the results. I have no idea why... anyone? <? $connectionstring = odbc_connect("DB", "", ""); if (isset($_GET["id"])) { $query = "SELECT * FROM notes WHERE note_id = $_GET[id]"; $result = odbc_exec($connectionstring,$query); While( $rows = odbc_fetch_array($result) ) { $note_id = $rows['note_id']; $note_title = $rows['note_title']; $note_content = $rows['note_content']; $note_date = $rows['note_date']; $note_date = strtotime($note_date); $note_date = date("l, jS F, Y", $note_date); $note_content = str_replace("/n", "<br>", $note_content); $note_content = stripslashes($note_content); $note_link = $rows['note_link']; //Display results echo("<p><span class=noteheading>$note_title</span><br>"); echo("<span class='notedate'>$note_date</span><br>"); echo("<br>"); echo("$note_content</p>"); if ($news_link= "") { if (!strpos($note_link,"http://")) { $link="http://".$note_link; } else { $link=$note_link; } echo("<p><b>For further information go to <a href='".$link."' target='_blank'>". $note_link . "</a></b></p>"); } echo("<br clear='all'>"); } echo("<p><a href='index.php'>« Back to Items</a></p>"); } else { $connectionstring = odbc_connect("Intranet", "", ""); $query = "SELECT * FROM notes WHERE (Date()-60) <= note_date ORDER BY note_date DESC, note_id DESC"; } $result = odbc_do($connectionstring, $query); if (odbc_fetch_array($result)== "") { echo "There are currently no Staff News items available."; echo("<p><a href='../index.php'>« Back to Home Page</a></p>"); } While( $rows = odbc_fetch_array($result) ) { $note_id = $rows['note_id']; $note_title = $rows['note_title']; $note_content = $rows['note_content']; $note_date = $rows['note_date']; $note_date = strtotime($note_date); $note_date = date("l, jS F, Y", $note_date); $note_content = stripslashes(FirstPara($note_content)); // only show first paragraph of article //Display results echo("<p>"); echo("<b><a href='index.php?id=$note_id'>$note_title</a></b><br>"); echo("<span class='notedate'>$note_date</span><br>"); echo("<span class='notecontent'>$note_content<br>"); echo("<a href='index.php?id=$note_id'>Read full article »</a></span></p>"); } if ($result == "") { echo $result; echo "There are currently no items available"; echo("<p><a href='../index.php'>« Back to Intranet Home Page</a></p>"); } ?>color]