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

Dynamic field names in recordset [message #169673]

Wed, 22 September 2010 13:01

Pedro M. Leite
Messages: 5
Registered: September 2010

Karma:

Junior Member

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

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: Sun Nov 10 17:12:39 GMT 2024

Total time taken to generate the page: 0.04970 seconds