Show all fields after a certain field in mysql

[penguin0]

Is there a way to show all fields in a table after a certain field, lets call it "position".  If so please provide the code.

[AndyB]

What are you trying to achieve?  Do you want to know the fields, or the data in them?

[penguin0]

EDIT:I need to print the fields so I can use them in an edit script.

[penguin0]

I guess I would need a loop to print the field name into this so i can directly pull from the db instead of making a new one for each:

 

			<label>
			<input type="radio" name="rateman" value="1" ' .  ($urateman == 1 ? 'checked="checked"' : '') . ' /> Yes 
			<input type="radio" name="rateman" value="0" ' .  ($urateman == 0 ? 'checked="checked"' : '') . ' /> No
		</label>

[penguin0]

can someone at least tell me how to print the fields after a certain field?

[gabeg]

have you tried using LIMIT? ie if your position is 4..LIMIT 5,100

[AndyB]

have you tried using LIMIT? ie if your position is 4..LIMIT 5,100

 

That's how you restrict how many records are processed, not how many fields (out of an unknown number).

[penguin0]

I guess this is not possible then?

[AndyB]

It's a bit weird, but you could workaround your problem by using the list-fields query, and creating an array of the database fields (in the order that they exist) then selecting all (*) fields and only outputting data for fields after the one you designate.

 

http://aspn.activestate.com/ASPN/docs/PHP/function.mysql-list-fields.html

 

I'll leave it to you to figure that one out