Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Contribution Tracking Contribution help please


lildog

Recommended Posts

I have put the finishing touches on a contribution that lets you know when an update has been made available. but I need one more piece I need an SQL query like this that works....

 

tep_db_query("UPDATE " . TABLE_CONTRIB_TRACKER . " SET status ='0', contr_last_modified = '" . $pubtimestamp . "' , date_status_change = now() where contrib_name = '" . $thetitle . "'" && last_update < '" . $pubtimestamp . "');

 

it all works except the greater than equation. basically it updates an entry if it is older than that of the date on the rss feed.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...