Exporting new records

Posted on 16th Feb 2014 07:03 pm by admin

Trying to figure out the best way to set this up.

People register my site.

Their profile has the date they registered.

I've got another table called 'markets' which has some information that is specific to various cities that the people who register are in.

One of the columns in markets is a toggle to determine whether that market should be exported

ie: Austin - export: 1
Boston -export: 0

My goal is to grab all of the new profiles for all markets where export = 1

I added a datetime field to the markets table.

I'm confused how to proceed however though

I was originally thinking grab the datetime from markets and select the stuff that is newer than that, then remembered I am dealing with more than 1 market.

Then I thought 'well just have a table that stores the last export date and select the newer stuff than that' but I wasn't sure if that would work either.

Advice?

Your Answer:

Login to answer

Other forums

Gantt Chart Tool
Does anyone know of a good free gantt chart creator tool

Thanks

browse folder only
hi,
is there a way i can browse or get the directory or folder only and not the file?
i just w

Production of mango in processing industry
Hi,

We have one scenario ,company is in process industry,they are manufacturing MANGO pul

Dynamic Array using glob?
Is there an easier way to do this?

I am trying to get create a dyamic array based on files wi

Thread in PHP
Thread in PHP
Some basic use and basic code for thread in php
This is my question?

session checking in page load
hai all I have a web site is www.Mryas.com in this my login page is Page1.aspx its co

please fix the error
What is the error in the below code ???
Line number On/Off | Expand/Contract <?php

remove innitial

and

tags
i am using tiny_mce as a text editor for my CMS.
buy now the problem is it add <p>

. and .. appearing instead of pictures
First of all, thanks very much for providing this forum. It is very much appreciated!

My son

need help in update query
hi
i have a dynamic form. i need help in how can i use update query when values from dynamic for