Help with PHP/SQL to change order of fields in table

ady189

Newbie

Join Date: Apr 2007

Posts: 1

#1: Apr 10 '07

Does anyone know of an SQL statement that i can use to change the order that a field appears in a table?
For example i have a table called entry with several fields in it.
The 2 that i want to swap locations are etitle and eurl..

They basically need to swap places.

The table only contains 9 fields. etitle is currently the 2nd in the list and eurl is the 7th.

I basically want to have the colums switched in the website..

Any help would be much appreciated...

Regards

Adrian (Newbie)

« previous question | next question »

Similar PHP bytes

PHP redirect after posting (answers)
Cannot use mail() in IE, only works in a debugger--help (answers)
Help with browsing db (answers)
Trouble with system() function (answers)

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,537 network members.