BLANK SPACE problem

[fantic]

i made a table where catID and catName name is given and inserted different data when i want to show data and made query like this: "select CatName from table_name where CatID=category_id order by CatName ASC" than result shows like this:

 

|  NewMan                                          |

|  NewVision                                        |

|  Sherpa High Ambitions                        |

| Abound Asian                                    |

| Above The Clouds                              |

| Ace The Himalaya                              |

| Acme Show                                      |

 

how i can fix this problem?

[JasonLewis]

So what's the problem exactly?

[fantic]

problem is sorting

[JasonLewis]

How do you want it to sort? Please explain your problem more clearly, because I still don't know what you want to do.

[fantic]

the problem is in ordering result which is givan above. ordering is not correct.

[PFMaBiSmAd]

There appear to be spaces at the start of the first 3 lines. You should always validate your data before inputting it into a database and if you don't want any spaces at the beginning or end of a string, you need to use the php trim() function on it before placing it into a query.

[rhodesa]

you *should* be able to do:

UPDATE table_name SET CatName = TRIM(CatName)

 

MAKE SURE YOU BACKUP YOUR DATA BEFORE DOING GLOBAL UPDATES LIKE THIS