Main Menu

PHP Tools
PHP Help Request
PHP Editors Newsletter
Editor Search
Reviewed PHP Editors
Latest News
Submit News
PHP Tutorials
PHP Book Reviews
Online Book Chapters
PHP Games

Forums

PHP Desktop Editors
Other PHP Tools
PHP Contests
PHP Programming Help
Linux Help
Apache Help
MySQL Help
PHP Games
PHP Jobs
PHP Forums Home

Programming Contest

PHP Contests
PHP Contests Archive

Documentation

PHP Manual
PEAR Manual
PHP-GTK Manual
Smarty Manual
PostgreSQL Manual
CSS 2 Reference
Redhat Linux 9
HTML 4.01
Apache 2 Manual

Partner Sites

MDB_Common::fetchCol()

MDB_Common::fetchCol() -- Fetch a single column

Synopsis

require_once 'MDB.php';

array &fetchCol (resource $result, mixed [$colnum = 0])

Fetch a single column from a result set of a result set and free the result set.

resource $result: a valid resource returned by query() or executeQuery()
array $params: if supplied, prepareQuery()/ executeQuery() will be used with this array as execute parameters
mixed $colnum: which column to return (integer [column number, starting at 0] or string [column name])

array - the first row of results as an array indexed from 0 or a MDB_Error, if fail

Table 33-1. Possible PEAR_Error values

Error code	Error message	Reason	Solution
`MDB_ERROR_TRUNCATED`	`NULL`	The result set contains fewer then two columns	Check the SQL query or choose another *query()** function
every other error code		Database specific error	Check the database related section of PHP-Manual to detect the reason for this error. In the most cases a misformed SQL statment. Ie. using LIMIT in a SQL-Statment for an Oracle database.

This function can not be called statically.

query() , limitQuery() , prepareQuery() , executeQuery() , fetchRow() , fetchOne() , fetchAll()

Prev	Home	Next
MDB_Common::fetchAll()	Up	MDB_Common::fetchOne()