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

Wed, 22 September 2010 17:13

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

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.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

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:54:47 GMT 2024

Total time taken to generate the page: 0.04476 seconds