Jump to content

Archived

This topic is now archived and is closed to further replies.

feri_soft

Error and question

Recommended Posts

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!

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
[!--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.

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.