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.

Did you know?Explore Trending and Topic pages for more stories like this.
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

PECL uploadprogress for php5.2
Hey, I just installed PHP5 via .htaccess on my 1and1 Shared Hosting Account.

How would I exac

Just cannot get 'area' to submit to db using same php code as already used
Basically all i have done is just modified some code and added an area section.
The form is allre

problem with script manager
Hi iam using Net.2005.I have created ajax enabledwebsite.i have master page in which i have script m

Simple program to copy files between two computers over the web
I use logmein free and often need to move files between my two computers. Generally, I move the file

Connect to database that isn't localhost
I am currently doing a small script for a company that doesn't have mySql support on there hosting.

multipart emiail forms
Hi All,

I am new to the boards and I've been working on a form (which is rather massive, imo

Auto-populating dropdowns and multiple forms.
Here's what I have so far:

First drop down = select a state (works)
This populates the sec

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

Oracle11g Patch issue
Hi all,

I'm getting the following error while installing Oracle11g Patch 11.1.0.7.0 on IBM-AI

Using Windows message as a Handle
Hi,

I am writing one of my first multithreaded programs.

In one of the thread,

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