Can php mysql server sort?

[11Tami]

Hello, is there a way to make mysql server sort its fields? Like if I wanted the fields to appear by alphabet of the name instead of just which one was entered first.

 

Please let me know if you can sort these fields, I looked everywhere can't see how to do it, yet other databases can sort. Please let me know, thank you very much.

[MadTechie]

Erm

 

you mean " Order By " something else?

can you show some sample code please

[11Tami]

Thanks, first there is the whole database, then the tables. Then all the fields in each table. The fields in the table is what I need sorted. So right now I have many fields in one table. The first field is listed as "name." With other fields after it. When I click on browse to look at all the rows that have been entered, the rows are not listed alphabetically. Instead they are listed by which row was entered first and last.

 

Another way to explain it. There are forms on the web pages. Each person comes along and enters their information. It is sent to the database. Each entry for each person appears as a row in the fields. So I have all these rows being added. But they are being with the last one being added at the end. Instead of alphabetical by what their name is.

 

Fields, first field is name  [name] [information]

Rows                            [Tami]  [Tamisinfo]  [grey]

                                  [betty] [bettyinfo]  [blue]

 

I'd like it to be alphabetical by name, so that Betty would come before Tami. Not Betty last just because she entered her stuff in after Tami. Either sorted alphatically automatically when they are added. Or sorted when I come along later and hit a button to sort everything. Hope someone knows a way. Thank you very much.

 

 

 

[MadTechie]

SO in the SQL statement use something like

 

SELECT * FROM table1 ORDER BY field1, field2

[Crusader]

"SELECT field FROM table ORDER BY field DESC"

 

I might have wrote that backwards so if it outputs the wrong try ASC instead of DESC.

[11Tami]

Thanks, so you can't sort the fields? You can only pull them out of the database alphabetically?

[MadTechie]

What!

each time you pull a record you can print the fields to the screen in any order you wish!

 

i think your need to provide some code as what your saying sounds a little weird

 

maybe

SELECT name, infomation, color, etc FROM tabel1

 

will work!!

[11Tami]

What I mean is, are you saying there is no button in the database itself anywhere?

 

A button that you can push that says "sort by" like other databases have? I don't know what your code means or what to do with it.

[MadTechie]

OK first off,

 

the "Button" the "Programmer" creates, this then executes a command to which tells the server to sort the records the command is "SELECT * FROM table1 ORDER BY field1, field2" (with options filled in).

 

this is MySQL not FileMaker

[11Tami]

Ok thanks, where do I put your code?

[MadTechie]

its an example, just update your SQL statement,

 

or post your SQL statement

[11Tami]

You should be able to tell  I don't know what I'm doing. You mean the statement on the page? Or do I insert it at the database? Thanks.

[MadTechie]

please post your code (in the code tags) please