Re: "Sense" last record

[Mário Gamito <mgamito@xxxxxxxxx>]

Hi,

Thank you all for your answers.

I solved the problem with:

<div id="blocoNews">
 <?php
  include('config.php');
  include('adodb/adodb.inc.php');

  $debug = 1;

  // connect to MySQL
  $conn->debug=1;
  $conn = &ADONewConnection('mysql');
  $conn->PConnect($host,$user,$password,$database);

  // insert subscription values
  $recordSet = &$conn->Execute("SELECT id_news, date, now, title, lead, 
body FROM news ORDER BY now DESC LIMIT 3");

  $counter = 0;

  if (!$recordSet)
   print $conn->ErrorMsg();
  else
   while (!$recordSet->EOF) {
    $counter++;
     if ($counter == 3)
      $div = '<div class="blocoTextoLast">';
     else
      $div = '<div class="blocoTexto">';
    print($div);
    print '<h3>' . $recordSet->fields[3] . '</h3>' . '<p class="data">' 
 . $recordSet->fields[1] . '</p>' . '<p>' . $recordSet->fields[4] . '<a 
href=news.php?news='. $recordSet->fields[0] . '>[+]</a>' . '</p>' . 
'</div>';
   $recordSet->MoveNext();
   }

 echo "<br class=\"clear\">";	
 $recordSet->Close();
$conn->Close();
?>
<!-- end #secContent --> 	
</div>

Warm Regards
--
:wq! Mário Gamito

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php