[Typo3] exec_SELECTquery Question

[Nick Weisser]

Hi there,

Why does the exec_SELECTquery return less result rows than an orinary 
SQL query?

I have this here in an extension

$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
	'name, firstname, place, phone',
	'user_phonelist_entries',
	'name != "" AND firstname != "" AND deleted = 0 AND pid = "24"',
	'name');

which returns only 171 result rows.

When I execute this query directly on the command line like so

SELECT name, firstname, place, phone
FROM `user_phonelist_entries`
WHERE name != ""
AND firstname != ""
AND deleted =0
AND pid = "24"
ORDER BY `name` ASC;

I get 206 result rows.

How is this possible? I could not explain this behaviour even after 
studying class.t3lib_db.php

Any pointers welcome :-)
-- 
Regards
Nick Weisser

Openstream Internet Solutions
http://openstream.ch