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?
TimeZoneOffset
Hello,Please i need your help. I have a system that users can use to punch in and out. This system has been working fine however the time went one hour behind on sunday and since then the system has
How to show the difference between two data field in a database with php.
Hello php gurus,how r u all... i'm not so well facing a typical problem please help me...i'm working with php and mysql.my problem is...in a data base have two integer field like parent_id &
building a function with multiple outputs
I want to build a function that has multiple outputs.I know but am not to sure how I should go about that, the only thing I know won't work is return a;return b;return c; that will return one result
show random images
hey guyscan someone please suggest a way in which the following code can be edited so it only picks up .jpg files, and so it only shows 20 of them which where found, in a randomized orderCode:
Making multiple rows with one query
I have a table called efed_handler_characters with two fields handler_id and bio_id. What query 2 is supposed to do is get the id from the handler and then with each char(acter) is supposed to make a
Replacing a string on click of a button
Hi! Is there a way to replace a string on a click of a text link?This is what I've come up with. It doesn't work at all ^^;;Code: <head><?php $string = Red;function changeBlue()
opening a window with after form submission
I know this this forum has nothing to do with JS, but i'm trying to use it with my php script. What i'm trying to do, and i'm not 100& sure i'm doing right, is after someone has submitted the
Turning Data into URLs?
This may seem very basic to you, but I'm having a hard time figuring out how to do this since I don't even know what the proper term for it is:Background info:Animals Table - animalid, name, photo,
form class help (oop php5)
Hidy Ho Neighbors,I'm forcing myself to learn oop/classes for php5. It seems like a good idea for repetitious coding such as with forms. I've been through the oop tutorials here and elswhere in
CRM?
I think that's what they're called. Customer Management System? Anyway. Is there any good free ones I could give a try? I was going to script one but what I want it for was confusing me when I was
