What happens when you print out journal?: print_r( $journal ); Are your keys the exact case as your table fields? ID vs id or Date vs date -----Original Message----- From: Eternity Records Webmaster [mailto:webmaster@xxxxxxxxxxxxxxxxxxx] Sent: Wednesday, December 07, 2005 11:31 PM To: php-general@xxxxxxxxxxxxx Subject: broken code.... I have this code that doesnt print the db results like they should... it uses pear::db package for the database. Was wondering if anybody can figure out how come it doesnt work... <?php require_once 'DB.php'; error_reporting('E_ALL'); $db =& DB::connect('mysql://root:3987957@localhost/eternityrecords'); if (PEAR::isError($db)) { die($db->getMessage()); } $results->query('select * from eternityrecords.journal'); if (PEAR::isError($results)) { die($db->getMessage()); } //test the results out.. ?> <table> <?php while($results->fetchInto($journal, DB_FETCHMODE_ASSOC)){ ?> <tr> <td><?php echo $journal['ID']; ?></td> <td> <?php echo $journal['Date']; ?> </td> <td> <?php echo $journal['Subject']; ?> </td> <td> <?php echo $journal['Entry']; ?> </td> </tr> <?php }?> </table> <?php $db->disconnect(); ?> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
