Re: Retrieving Rows - Can I Change The Order?

> Now then, I have changed a column in the table, and the only way I found to > change a data type is to delete the offending column and then add it again. > > When I do the select now the new column, which was at $row[3] is now always > $row[39]. I don't mind this, because I know where it is, but is there any > way I can make it appear at $row[3] again? I'm sure you can imagine when > there are quite a few pages using this code it's easier to reorder the > columns in the select than to change all my if() codes! Maybe I am missing what you are trying to do but it sounds like you are just trying to sort your columns. If that is what you are asking then why dont you do your query like this: select * from $table where $column = '$value' ORDER BY $column I hope this is what you were asking and that is helps you out. > > By the way, I know I can be explicit by SELECTing each column by name, but > I'ds rather use a SELECT * fror this partucular instance. > > Any ideas? Or am I just being lazy (it's been a long night after all!)? > > > TIA > > > Dave