PHP help please

admin · 24-04-2011, 09:58:40 PM

Hi all,

I am trying to get records from a DB where the date in a field is todays date, or the next day's date:

Code:

`fieldname` > date_SUB(CURdate(), INTERVAL 2 DAY)

doesn't work.

Any help please?

Thanks

Admin

JDubya · 24-04-2011, 11:19:08 PM

Is the format of the date field in the DB table DATETIME instead of DATE?

DATETIME = YYYY-MM-DD HH:MM:SS
DATE = YYYY-MM-DD

Because CURDATE() returns the date in the format YYYY-MM-DD, which means if the date field was DATETIME then it would not match (the hours, mins, secs throwing it off) .

If so, you can use DATE_FORMAT to change the value extracted from the DATETIME field. For example:

PHP Code:

  SELECT * FROM table WHERE DATE_FORMAT( datetime_field, '%Y-%m-%d' ) = DATE_SUB( CURDATE(), INTERVAL 2 DAY )

admin · 24-04-2011, 11:57:25 PM

Thanks for the suggestion.

The field type is "int(10)" and shows a string of numbers which I assume is a Unix format date string.

Admin

JDubya · 25-04-2011, 12:09:53 AM

In that case could try:

HTML Code:

SELECT * FROM table WHERE FROM_UNIXTIME( fieldname, '%Y-%m-%d' ) > date_SUB( CURDATE(), INTERVAL 2 DAY )

admin · 25-04-2011, 12:16:28 AM

Didn't work.. no errors but no effect on SELECT statement results either

JDubya · 25-04-2011, 12:26:52 AM

Quote:

SELECT fieldname, FROM_UNIXTIME( fieldname, '%Y-%m-%d' ), CURDATE(), DATE_SUB( CURDATE(), INTERVAL 2 DAY )
FROM table
LIMIT 5

Paste in the results of the above query here - might make it easier to spot something...

admin · 25-04-2011, 03:13:13 PM

It just selects all the records instead of just the ones with 2 days difference from today's date.

admin · 26-04-2011, 08:04:03 PM

Got that sorted after playing about for hours.

Now I'm build a PHP to RSS script, how do I add a URL link in the following line:

Code:

$rssfeed .= '<link>' . $classifiedid . '</link>';

so link to http://www.acorndomains.co.uk/vbclas....php?do=ad&id=[$classifiedid field here]

Thanks

Admin

seemly · 26-04-2011, 08:13:07 PM

admin sorted code anyway. =)

admin · 26-04-2011, 08:16:42 PM

Never mind fixed it, needed to use the "htmlentities" tag.

Acorn forum auctions now has an RSS feed :

http://www.acorndomains.co.uk/auctions-rss.php

24-04-2011, 09:58:40 PM	#1 (permalink)
admin Administrator Join Date: Jun 2004 Posts: 8,601 No Classified Ratings Domain Trader Rating: (100% / 1)	PHP help please Hi all, I am trying to get records from a DB where the date in a field is todays date, or the next day's date: Code: `fieldname` > date_SUB(CURdate(), INTERVAL 2 DAY) doesn't work. Any help please? Thanks Admin __________________ Domain Appraisal \| Domain Scripts \| Domain Software\| link to Acorn Domains

24-04-2011, 11:19:08 PM	#2 (permalink)
JDubya Member Join Date: Apr 2010 Location: Buenos Aires Posts: 83 No Classified Ratings Domain Trader Rating: (100% / 1)	Is the format of the date field in the DB table DATETIME instead of DATE? DATETIME = YYYY-MM-DD HH:MM:SS DATE = YYYY-MM-DD Because CURDATE() returns the date in the format YYYY-MM-DD, which means if the date field was DATETIME then it would not match (the hours, mins, secs throwing it off) . If so, you can use DATE_FORMAT to change the value extracted from the DATETIME field. For example: PHP Code: `SELECT * FROM table WHERE DATE_FORMAT( datetime_field, '%Y-%m-%d' ) = DATE_SUB( CURDATE(), INTERVAL 2 DAY )`

24-04-2011, 11:57:25 PM	#3 (permalink)
admin Administrator Join Date: Jun 2004 Posts: 8,601 No Classified Ratings Domain Trader Rating: (100% / 1)	Thanks for the suggestion. The field type is "int(10)" and shows a string of numbers which I assume is a Unix format date string. Admin __________________ Domain Appraisal \| Domain Scripts \| Domain Software\| link to Acorn Domains

25-04-2011, 12:09:53 AM	#4 (permalink)
JDubya Member Join Date: Apr 2010 Location: Buenos Aires Posts: 83 No Classified Ratings Domain Trader Rating: (100% / 1)	In that case could try: HTML Code: SELECT * FROM table WHERE FROM_UNIXTIME( fieldname, '%Y-%m-%d' ) > date_SUB( CURDATE(), INTERVAL 2 DAY )

25-04-2011, 12:16:28 AM	#5 (permalink)
admin Administrator Join Date: Jun 2004 Posts: 8,601 No Classified Ratings Domain Trader Rating: (100% / 1)	Didn't work.. no errors but no effect on SELECT statement results either __________________ Domain Appraisal \| Domain Scripts \| Domain Software\| link to Acorn Domains

25-04-2011, 03:13:13 PM	#7 (permalink)
admin Administrator Join Date: Jun 2004 Posts: 8,601 No Classified Ratings Domain Trader Rating: (100% / 1)	It just selects all the records instead of just the ones with 2 days difference from today's date. __________________ Domain Appraisal \| Domain Scripts \| Domain Software\| link to Acorn Domains

26-04-2011, 08:04:03 PM	#8 (permalink)
admin Administrator Join Date: Jun 2004 Posts: 8,601 No Classified Ratings Domain Trader Rating: (100% / 1)	Got that sorted after playing about for hours. Now I'm build a PHP to RSS script, how do I add a URL link in the following line: Code: $rssfeed .= '<link>' . $classifiedid . '</link>'; so link to http://www.acorndomains.co.uk/vbclas....php?do=ad&id=[$classifiedid field here] Thanks Admin __________________ Domain Appraisal \| Domain Scripts \| Domain Software\| link to Acorn Domains

26-04-2011, 08:13:07 PM	#9 (permalink)
seemly Join Date: Feb 2011 Location: Gosport - UK Posts: 518 No Classified Ratings Domain Trader Rating: (100% / 10)	admin sorted code anyway. =) Last edited by seemly; 26-04-2011 at 08:18:25 PM. Reason: Admin sorted code himself

26-04-2011, 08:16:42 PM	#10 (permalink)
admin Administrator Join Date: Jun 2004 Posts: 8,601 No Classified Ratings Domain Trader Rating: (100% / 1)	Never mind fixed it, needed to use the "htmlentities" tag. Acorn forum auctions now has an RSS feed : http://www.acorndomains.co.uk/auctions-rss.php __________________ Domain Appraisal \| Domain Scripts \| Domain Software\| link to Acorn Domains

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Domain Name Community	Replies	Last Post
Experienced freelance developer available (PHP, MySQL, Wordpress, feeds, APIs, etc.	MartinWood	Scripts and Coding	0	06-09-2010 11:33:05 AM
Which PHP framework	monaghan	Scripts and Coding	6	22-07-2010 08:31:56 PM
PHP include in a Smarty Template	admin	Scripts and Coding	1	13-05-2008 06:37:26 AM