RE: [PHP] broken code....
| From: | Mark Steudel | Date: | Thu, 08 Dec 2005 18:10:38 +0000 |
| Subject: | RE: [PHP] broken code.... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-227150@lists.php.net to get a copy of this message | ||
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@eternityrecords.org]
Sent: Wednesday, December 07, 2005 11:31 PM
To: php-general@lists.php.net
Subject: [PHP] 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