> Greetings all,
>
> The problem is, it is returning the second newest or last record, not the 
> very newest or last record.

I don't think it's an mysql mistake but a php one.
Maybe you run mysql_fetch_*() twice before you access the row data?
But this might not work if you have "limit 1" (when coded correctly).

> I have thousands of records in a mysql database and I'm trying to do what 
> I thought would be a simple select statement using either max() or limit 1 
> DESC.
>
> Is this comon or am I just missing a simple step?

Maybe there are records added just in time? 



------------------------ Yahoo! Groups Sponsor --------------------~--> 
<font face=arial size=-1><a 
href="http://us.ard.yahoo.com/SIG=12hkp1gcv/M=362329.6886308.7839368.1510227/D=groups/S=1705005703:TM/Y=YAHOO/EXP=1123787231/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992
">Fair play? Video games influencing politics. Click and talk back!</a>.</font>
--------------------------------------------------------------------~-> 

Community email addresses:
  Post message: [email protected]
  Subscribe:    [EMAIL PROTECTED]
  Unsubscribe:  [EMAIL PROTECTED]
  List owner:   [EMAIL PROTECTED]

Shortcut URL to this page:
  http://groups.yahoo.com/group/php-list 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/php-list/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to