[fpc-pascal]MySQL question...

Mirek Novak mirek.novak at auto.cz
Thu Jul 4 09:46:04 CEST 2002


Rainer Hantsch wrote:
> Hello, everybody!
> 
> Currently I am thinking about enhancing my MySQL unit, because it currently
> does only a very simple way of querying. I use Michael's "mysql" unit and made
> another "layer" on top of it, preventing me from doing too much particular
> things repeatedly.
> 
> My biggest problem is that this mysql unit returns the data in form of an
> array [0..n], which does not really make it easier to pick out a particular
> field. So I want to write a function which gets a field name passed and
> returns me the content. For that purpose I need to query the field names of a
> table, but I do not know, HOW.
> 
> Can somebody help, please?
> 
> 
> mfg
> 
>   Ing. Rainer Hantsch
> 


Take a look at mysql manual in section Mysql API - MySql C API u have list of functions with small examples - all u need. In your 
case U probably need function mysql_fetch_fields(...)

<FROM MANUAL>
8.4.3.16 mysql_fetch_fields()
   MYSQL_FIELD *mysql_fetch_fields(MYSQL_RES *result)
   Description
     Returns an array of all MYSQL_FIELD structures for a result set. Each structure provides
     the 
eld de
nition for one column of the result set.
   Return Values
     An array of MYSQL_FIELD structures for all columns of a result set.
   Errors
     None.

Example

unsigned int num_fields;
unsigned int i;
MYSQL_FIELD *fields;
num_fields = mysql_num_fields(result);
fields = mysql_fetch_fields(result);
for(i = 0; i < num_fields; i++)
{
printf("Field %u is %s\n", i, fields[i].name);
}
</FROM MANUAL>

-- 
--
Mirek Novak
Anima Publishers
CMS development

http://www.auto.cz
http://www.formule1.cz

jabber:mirek at njs.netlab.cz
ISEEKYOU:1<one>9<four>9<nine>44<eight>
GEsEm:+420603807838





More information about the fpc-pascal mailing list