Error and question

[feri_soft]

I have one query which list all from the table where id=....,but the articles aren't ordered by date.

for exa mple

1 04/04/2006
2 07 /04/2006


i tried by adding order by date desc and nothing happened.Any ideas about that please?

And the second.I want to add a field with url address to an image and then when listing the data from the db to size the image for example to 100x100 px without using any GD's

Help me please!

[kenrbnsn]

What is the format of the field where the date is stored? If it is not 'date' or 'datetime' the "order by" won't sort by date. It will sort by ascii order.

Ken

[feri_soft]

so i must change it to date or try sorting by id ??

[inztinkt]

[!--quoteo(post=366127:date=Apr 18 2006, 10:17 PM:name=feri_soft)--][div class=\'quotetop\']QUOTE(feri_soft @ Apr 18 2006, 10:17 PM) [snapback]366127[/snapback][/div][div class=\'quotemain\'][!--quotec--]
so i must change it to date or try sorting by id ??
[/quote]
well changing it to date format will make sorting by date possible, however if there is no way for a user to overide the date when inserting or updating the table, sorting by id would work.

[feri_soft]

And any ideas about resizing images.I supose if the url is inserted into the table then list all articles and the images to them while changing image sizes,but i ha e never worked with images finctions in php 5. H ow to use them exactly?

[feri_soft]

bumping?