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 #169683 is a reply to message #169682]

Wed, 22 September 2010 17:30

Pedro M. Leite
Messages: 5
Registered: September 2010

Karma:

Junior Member

On 09/22/2010 06:13 PM, Jerry Stuckle wrote:
> On 9/22/2010 9:01 AM, 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
>
> What you need to do is join the tables and order by the position. For
> more information, please follow up in comp.databases.mysql. They will
> want the output of your CREATE TABLE statements and some sample data
> plus exactly what you want output.
>

thanks, but that's not quite it
my question is :
<short version>

this is correct in php
--> $row_customers['id'];

being 'id' the name of the field

question
--> can this be done ??
---> $row_customers[$a_variable_that_contains_'id'_or_something_else]

the $a_variable .. is collected from another recordset that contains
field names and their position, ordered by position

thank you and sorry for not making myself clear

Best Regards
PLeite

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:36:08 GMT 2024

Total time taken to generate the page: 0.04017 seconds