BIG Sorting and Searching Problem

M

Michael

Guest
Maybe this is a dumb question, but I am no MySQL pro. searching this forum gave me no answer.

By sorting the search-results 100000 appears smaller than 50000, but I do not want to edit and display 050000. You know what I mean?

Same Problem appears by searching my tables on everything larger than i.e. 50000. This search gives the results just between 50000 and 99999 but no results bigger than 100000.

Both problems go together, sure, but is there a way to fix this? Please do not tell me to edit 050000 instead of 50000.

I am using dadabik 2.2.1

Thanks
 
E

Eugenio

Guest
Michael wrote:

> Maybe this is a dumb question, but I am no MySQL pro.
> searching this forum gave me no answer.
>
> By sorting the search-results 100000 appears smaller than
> 50000, but I do not want to edit and display 050000. You know
> what I mean?
>
> Same Problem appears by searching my tables on everything
> larger than i.e. 50000. This search gives the results just
> between 50000 and 99999 but no results bigger than 100000.
>
> Both problems go together, sure, but is there a way to fix
> this? Please do not tell me to edit 050000 instead of 50000.

The corresponding MySQL field must be numeric (int, float....).



(Latest version of DaDaBIK when this message was posted: 2.2.1)
 
Top