Hodges |
|
---|---|
Hi there, I'm working on a plugin and I've run into something bizarre I can't figure out. I've got the following exmaple DB table: CREATE TABLE IF NOT EXISTS `cot_test` ( `test_id` int(10) NOT NULL auto_increment, `test_title` varchar(255) character set latin1 NOT NULL, PRIMARY KEY (`test_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ; INSERT INTO `cot_test` (`test_id`, `test_title`) VALUES (1, 'one'), (2, 'two'), (3, 'three'), (4, 'four'), (5, 'five'); And I've got this simple script to output the column 'test_title' in ascending order. $sql = $db->query("SELECT * FROM cot_test ORDER BY test_title ASC"); $row = $sql->fetch(); foreach($sql as $row) { $numberselect .= $row['test_title']."<br />"; } If I run the above SQL statement in phpMyAdmin I get:
If I run the script as part of my plugin I get:
The first row is always missing!! What silly mistake am I making? |