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

tag inside php...
hi


Code: <?php
echo "<td width="$columnWidth%" align=&

if description does not contain the following words
Hello everyone,

I am parsing a MS Excel (.xls) file and adding it's content to a mySQL databa

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here

An odd assignment statement. Can someone explain this assignment to me?
What purpose is served by the bit of code between the two equal signs in the $installurl set? Is th

weeks in a year
hi,

i found this snippet on php.net
QuoteFor the week number for weeks starting on Sunday:

PHP page loading in Firefox but not in IE
hello,

i am currently doing a project in PHP and i have a problem. If I view the project in M

Saving PHP output as a file
I wondered if anyone knows how to save the rendered output of a PHP script as a file?

I have

Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne

problem with sql querry in php script
Hello guys,

What I want to do is I want to read out a csv file and then but te conent ot the

Form Help
Here is the form:

Line number On/Off | Expand/Contract<? include("../include/sess

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