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

Sending CC Info by email
I am a little bit less knowledgable in the security area as most developers and I know I have a lot

Remove letter from numeric textbox
I have a textbox that will search the employee database by entering in the employee ID and it will r

Most basic form question ever?
Hello,

I want to use this snippet to make sure the fields in a form are ok before processing

Sufficient protection from bad input?
I am writing a simple script to let people upload 'pages' of their own content, be it simply a few b

output_buffering so rewrite
I'm planning to rewrite some of my scripts so they don't have to use output buffering to accomplish

SCRIPT ERROR
Here is the CONTACT FORM I made for our website:

<form id="form1" name="

my login script page is not working on remote computers
hi my login is working on my computer, but when i tried 2 computers from 2 different locations, they

help with calculations on a flat text file
hello,
I have this code below that is attached to a flat file like this:
Email:LastName:FirstN

Do something every fifth time?
I'm trying to write a loop, but I want it to do something different after every fifth instance. Like

update the selected existing records of database
Hi frndz,
I am new to php and get stuck....

Edit.php > Update.php > Updatea