FUDforum: comp.lang.php » Dynamic field names in recordset

Home » Imported messages » comp.lang.php » Dynamic field names in recordset

Show: Today's Messages :: Polls :: Message Navigator

Re: Dynamic field names in recordset [message #169676 is a reply to message #169673]

Wed, 22 September 2010 14:33

Robert Hairgrove
Messages: 19
Registered: September 2010

Karma:

Junior Member

Pedro M. Leite wrote:
> good afternoon
>
> sorry if i not make my self clear
> current situation
> one table with 50 fields - appx
> id - name - entrydate - remarks - width .... locked
> one page with :
> select from table where id = " - from $_GET
> read the recordset and output pdf
> rst_table['id']
> rst_table['name']
> rst_table['entrydate']
> ....
> rst_table['locked']
>
> 50 something times repeated
>
> now, i want to have a table with
> fieldname
> position
> so that i can :
> open a recordset from table with one row
> browse the position table, ordered by index, from 1 to 50 something
> in the loop, make
> (pseudocode) echo_to_pdf rst_table(position_table(fieldname))
> loop
>
> so that, to rst_table, the field i want is passed bu the content of the
> position_table field content, instead of literally :
> 'position_table(fieldname)'
>
> simple example
>
> main table
> id
> name
> remarks
>
> position table
> id,1
> name,2
> remarks,3
>
> so the output is : id - name - remarks
>
> OR
>
> position table
> id,1
> name,3
> remarks,2
>
> so the output is : id - remarks - name
>
> s, what i am looking to do is to reference the field by another
> reference and not literally
>
> thank you in advance
> Pedro Leite

You didn't specify what database you are using ... with most relational
databases (MySQL, Oracle, etc.) you can (and should!) refer to the field
by name and not by position.

You should not depend on the position of a column within a table! Most
of the time, the DBA is NOT the same person who is programming the
client application. So, what happens if someone adds a column to the
table, and doesn't tell you about it? Your code breaks, of course.

Report message to a moderator

[Message index]

		Dynamic field names in recordset By: Pedro M. Leite on Wed, 22 September 2010 13:01
		Re: Dynamic field names in recordset By: Robert Hairgrove on Wed, 22 September 2010 14:33
		Re: Dynamic field names in recordset By: Pedro M. Leite on Wed, 22 September 2010 15:52
		Re: Dynamic field names in recordset By: Pedro M. Leite on Wed, 22 September 2010 15:53
		Re: Dynamic field names in recordset By: Jerry Stuckle on Wed, 22 September 2010 17:13
		Re: Dynamic field names in recordset By: Pedro M. Leite on Wed, 22 September 2010 17:30
		Re: Dynamic field names in recordset By: Jerry Stuckle on Wed, 22 September 2010 19:12
		Re: Dynamic field names in recordset By: Robert Hairgrove on Wed, 22 September 2010 20:14
		Re: Dynamic field names in recordset By: Pedro M. Leite on Wed, 22 September 2010 22:31

Previous Topic:	How do we manage large code sets in PHP?
Next Topic:	Book problems and solution for windows 7

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 03:45:55 GMT 2024

Total time taken to generate the page: 0.03858 seconds