"fetch" function ordered by ID

Next topic

Author	Message
Roberta Gatti	Monday 15 March 2004 7:46:40 am hi, I have a problem using "fetch" function. I axtract data from database orderd by ID but the sistem put id 100 before id 99 so the result is: 100 101 102 103 99 instead of 99 100 101 .... This is an error but I don't know how resolve it TIA R.

Author

Message

Monday 15 March 2004 7:46:40 am

hi,

I have a problem using "fetch" function. I axtract data from database orderd by ID but the sistem put id 100 before id 99 so the result is:

100
101
102
103
99

instead of

99
100
101
....

This is an error but I don't know how resolve it

TIA
R.

eZ debug

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0065	590.4297	152.6250
Module start 'layout'	0.0065	0.0041	743.0547	39.4453
Module start 'content'	0.0106	1.3249	782.5000	402.2031
Module end 'content'	1.3355	0.0018	1,184.7031	8.1641
Script end	1.3373		1,192.8672

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0037	0.2744	16	0.0002
Check MTime	0.0014	0.1040	16	0.0001
Mysql Total
Database connection	0.0011	0.0850	1	0.0011
Mysqli_queries	1.2969	96.9770	46	0.0282
Looping result	0.0004	0.0336	44	0.0000
Template Total	1.3054	97.6	2	0.6527
Template load	0.0021	0.1591	2	0.0011
Template processing	1.3033	97.4525	2	0.6516
Template load and register function	0.0002	0.0157	1	0.0002
states
state_id_array	0.0014	0.1048	1	0.0014
state_identifier_array	0.0010	0.0754	2	0.0005
Override
Cache load	0.0017	0.1292	18	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0008	0.0597	1	0.0008
Fetch class attribute name	0.0006	0.0473	1	0.0006
XML
Image XML parsing	0.0001	0.0087	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0002	1	0.0000
General
dbfile	0.0006	0.0422	10	0.0001
String conversion	0.0000	0.0007	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
1	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
3	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 10 Number of unique templates used: 5

Time used to render debug report: 0.0002 secs