koughman

so without using mysql and using php is there a way i can get a script that shows the past 45 best entries?

[!--quoteo(post=343993:date=Feb 8 2006, 11:32 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Feb 8 2006, 11:32 PM) [snapback]343993[/snapback][/div][div class=\'quotemain\'][!--quotec--] You should check the syntax of the STR_TO_DATE() function -- you need to pass in your PHP date string, and then define how it is composed: for example, STR_TO_DATE('04/31/2004', '%m/%d/%Y'). Simply substitute your PHP date for the date string and you're done. [/quote] my date is like January 5th 2005 and im a n00b with php/mysql can one of you plz help with the exact script, thanks

so then [code]SELECT * FROM yourTable WHERE DATE_SUB(STRTODATE(), INTERVAL 1 MONTH)<=NOW() ORDER BY score DESC LIMIT 45[/code]

in this query[code]SELECT * FROM yourTable WHERE DATE_SUB(yourDate, INTERVAL 1 MONTH)<=NOW() ORDER BY score DESC LIMIT 45[/code] what do you mean by yourdate? like the date of the entry, in that case im using php date function and wouldnt that screw it up?

im looking for a mysql script to show the last 45 entries ordered by score in the past month, thanks