Set WeberTrivia.com to be my default homepage.   Suggest a Question                                               

Suggest A Question : :  Frequently Asked Questions : :  Search : :  Relevant Manuals : : 
PHP Questions : :  Linux Questions : :  MySQL Questions : :  		home  [ Login ] 
Log In
Email
Pass
Forgot Password?
New User, Register here.

Weber Sites
PHP Code Search
Web Development Resources
PHP & MySQL Code Examples
PHP Web Logs (BLogs)
PHP & MySQL Forums
Web Development Index
Web Site Templates
Web Development Manuals
Web Site Uptime Monitor
web development content

Relevant Manuals
PHP Manual
PEAR Manual
MySQL 5
MySQL 4.1.11
Apache 2
Apache 1.3.x

PHPClasses
Metaprogramming language
PHP Editor
PHP Jobs
Ajax Tutorials
Webmaster Resources
Web Templates
Webmaster Forum
Suggest your site



Forex Trading Online forex trading platform
Free Advertising
Search Engine Optimization - search engine optimization (SEO) and advertising specialist.
term paper writing by a team of professional writers.
More Info

PEAR Manual
PrevNext

DB_common::getCol()

DB_common::getCol() -- Fetch a single column

Synopsis

array &getCol (string $query [, mixed $col = 0 [, mixed $params]])

Description

Fetch a single column from a result set of a query. The function takes care of doing the query and freeing the results when finished.

Parameter

string $query

the SQL query or the statement to prepare

mixed $col

which column to return (integer [column number, starting at 0] or string [column name])

mixed $params

array, string or numeric data to be added to the prepared statement. Quantity of items passed must match quantity of placeholders in the prepared statement: meaning 1 placeholder for non-array parameters or 1 placeholder per array element.

If supplied, prepare()/ execute() is used.

Return value

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

Throws

Table 21-1. Possible PEAR_Error values

Error codeError messageReasonSolution
DB_ERROR_INVALID NULL SQL statment for preparing is not valid. See the prepare() documentation, if you want to use a SQL statemt using placeholders.
DB_ERROR_MISMATCH NULL Quantity of parameters didn't match quantity of placeholders in the prepared statment. Check that the number of placeholders in the prepare() statement passed to $query equals the count of entries passed to $params.
DB_ERROR_NODBSELECTED NULL No database was choosen. Check the DSN in connect().
DB_ERROR_TRUNCATED NULL The result set contains fewer then two columns Check the SQL query or choose another get*() function
every other error code  Database specific error Check the database related section of PHP Manual to detect the reason for this error. In most cases a malformed SQL statement is the cause of the error. (Ie. using LIMIT in a SQL-Statment for an Oracle database.)

Note

This function can not be called statically.

See

query(), limitQuery(), prepare(), execute(), getRow(), getOne(), getAssoc()

PrevHomeNext
DB_common::getAssoc()UpDB_common::getListOf()
Who's Online
Guest Users: 6
Google
Web
WeberTrivia
WeberDev
WeberForums
 Free Sample Chapters  Free Sample Chapters
  Deliver First Class Web Sites: 101 Essential Checklists
Want to learn how to make your web sites usable and accessible? Want to ensure that your sites meet current best practice, without spending hours trawling through incomprehensible specifications and recommendations from dozens of different books, research papers, and web sites? Want to make sure that the sites you build are "right the first time," requiring no costly redevelopments?

More Sample Chapters

PHP General