Jump to content


Photo

Error and question


  • Please log in to reply
5 replies to this topic

#1 feri_soft

feri_soft
  • Members
  • PipPipPip
  • Advanced Member
  • 147 posts

Posted 18 April 2006 - 03:30 PM

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!

#2 kenrbnsn

kenrbnsn
  • Staff Alumni
  • Advanced Member
  • 8,235 posts
  • LocationHillsborough, NJ, USA

Posted 18 April 2006 - 03:37 PM

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

#3 feri_soft

feri_soft
  • Members
  • PipPipPip
  • Advanced Member
  • 147 posts

Posted 18 April 2006 - 07:17 PM

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

#4 inztinkt

inztinkt
  • Members
  • PipPip
  • Member
  • 21 posts
  • LocationCyprus ( OnThisIsland )

Posted 18 April 2006 - 07:23 PM

[!--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) View Post[/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.
<!-- // Blah // -->
OnThisIsland.com

The greatest leader is not always he who holds the most power, but he who has the ability to do the most with the power he has. - Inztinkt is Distinct!

#5 feri_soft

feri_soft
  • Members
  • PipPipPip
  • Advanced Member
  • 147 posts

Posted 18 April 2006 - 07:28 PM

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?

#6 feri_soft

feri_soft
  • Members
  • PipPipPip
  • Advanced Member
  • 147 posts

Posted 19 April 2006 - 10:46 AM

bumping?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users