Jump to content


Photo

Getting the MAX() date problem: Error


  • Please log in to reply
2 replies to this topic

#1 massive

massive
  • Members
  • PipPipPip
  • Advanced Member
  • 40 posts

Posted 07 March 2006 - 03:34 AM

Hi guyz...its me again heheheh....i was wondering how to view only the recent data by refferring to its date my querying seems to be wrong...

For example:

a customer paid at the date of 2006-03-02...this is the last time he paid....so when i view his information the most recent date would be or should be view "2006-03-02"...not 2006-03-01...not 2006-02-28....etc...

$query = "SELECT * FROM dataz WHERE username = '$username' AND Dated = MAX(Dated) AS most";

"in here i have errors i know my placing of "max(date) as most" is wrong...this comes in handy if i do this"


$query = "SELECT *, MAX(Dated) AS most FROM dataz WHERE username = '$username'";


"i was wondering how could i do this in terms of using WHERE....."

Algorithm: Select everything from dates where this is the user and the date of the user is the most recent...



tnx...^__^

#2 shocker-z

shocker-z
  • Members
  • PipPipPip
  • Advanced Member
  • 864 posts
  • LocationNottingham

Posted 07 March 2006 - 10:43 AM

instead of using
SELECT *, MAX(Dated) AS most FROM dataz WHERE username = '$username'

You could try and use:
SELECT TOP 1 * FROM dataz ORDER BY dated DESC


that will order the date so latest is at the top and just select that single record.. i think :)
www: www.ukchat.ws | irc: irc.ukchat.ws chan: #blufudge

#3 massive

massive
  • Members
  • PipPipPip
  • Advanced Member
  • 40 posts

Posted 07 March 2006 - 10:50 AM

[!--quoteo(post=352445:date=Mar 7 2006, 05:43 AM:name=shocker-z)--][div class=\'quotetop\']QUOTE(shocker-z @ Mar 7 2006, 05:43 AM) View Post[/div][div class=\'quotemain\'][!--quotec--]
instead of using
SELECT *, MAX(Dated) AS most FROM dataz WHERE username = '$username'

You could try and use:
SELECT TOP 1 * FROM dataz ORDER BY dated DESC
that will order the date so latest is at the top and just select that single record.. i think :)
[/quote]


about the "TOP 1" thing is that the same with "LIMIT 1"?...anyways thanks shocker-z ^__^





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users