Re: MySQL sorting problem

U must split it into 2 or 3 fields S# and # or S and # and # . All attributes must be scalar (1st normal form). It's basics of theory of relational databases :o). M.N. De Necker Henri wrote: > Hi there > > I have the following problem : > My company has about a 1000 Skills that are associated to specific > employee's listed as : > S1.1 > S1.2 .... > S1.21 > S1.22 ... > S1.3 > S1.4 > S2.1 > S2.2 .... > > and so on. > All these must be listed by me in a db. > Now I have the problem a sorting them in a numeric way! > If I sort them "assenting" , my result will be S1.1, S1.11, S1.12 S1.13, > 1.2 and S1.3 > It must be S1.1, S1.2, S1.3, S1.11, S1.12 ex. > I have tried S1_1, S1_2, S1_3 ex. this also doesnt work. > > Is there different way I can list them or safe the in the db. > Any help will be appreciated > Thank u! > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net