Gets the column value for a given column.

Syntax

---

edb_getcol(<CursorHandle>, <ColumnNumber> | <ColumnName>)

<CursorHandle> =

Handle of cursor returned by edb_execute function

<ColumnNumber> = Ordinal position of column

<ColumnName> = Name of column

Returns

---

Column value if successful, or FALSE if there are any errors

Usage

---

The edb_getcolumn function retrieves the value of the specified column.

Examples

---

<?php

// The following script connects to an ElevateDB
// Server and database, prepares a columnized
// SELECT statement, executs the statement, and
// displays the column value for the first row
// using the edb_getcol() function

$con = edb_connect("type=remote;charset=Ansi;address=127.0.0.1;"+
                   "uid=Administrator;pwd=EDBDefault;database=Test");
if (!$con)
  {
  die("Could not connect: " . edb_errmsg());
  }

$cmd = edb_prepare($con,"SELECT * FROM customer WHERE State=:State");

edb_setparam($cmd,"State","FL");

$cursor = edb_execute($cmd);

echo edb_getcol($cursor,"State");

edb_disconnect($con);
?>