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?

No comments posted yet

Your Answer:

Login to answer
299 Like 35 Dislike
Previous forums Next forums
Other forums

Final year project, please point me in the right direction
hi there for my final year project I'm aiming to build a php script shell to use as an expert system

Customizing message/behavior
Hi,I'm using the ASP.NET membership/authorization controls in my application. Some parts of my appli

Interpret Order
Hello all,

I'm wondering if I have this:

Code: $switch = array(
'one' =>

function not returning the correct value
I have a program that needs to return a value from a function. I have an output statement inside the

this code is not working????
it says this error.. Warning: Division by zero in ..

the variables are correct, so why is th

PHP Thumbnail Creation
Ok so i use this function to create thumbnails:

Code: function createthumb($name,$filename,$n

PHP Redirecting
Hello everyone. Is there a way to redirect people to pages within a statement in PHP? Since there is

Insert to MySQL inside foreach
Hey.
I am parsing some html, and putting inside an html db.
I need to create a randomized inte

Impact of movement type 412 E on MAP
Hi

Usage of movement type 412 E is causing huge change in MAP .

Is there any r

sql problems
I am having a small problem with my sql statement. it is inserting into 4 of the fields.

fie

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash