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?
Multipe Dynamic Controls & AutoPostback Issue
I currently have a need to create many dynamic controls (Example Textboxes) that need to do a PostBack upon the data in the control changing (Autopostback = true). The following sample code
Images outside webroot
Im hopeing someone can help me with this because i cant figure it out.I have setup an ASP.NET website in C# that allows end users to upload files to the server. I am able to save these files outside
How do I give a developer access to a specific directory and nothing else?
I want to give a develop access to a specific directory and nothing elseI can give them an FTP account with access to a sub directory, but this doesn't exactly solve the problem!1. They can write PHP
How to use Substr
I want to check for the word CATEGORY: inside a string which can be CATEGORY: ITEMand remove the word CATEGORY: leaving only ITEM inside the string....In case the string does not have CATEGORY: before
count only commas outside parenteses
I have a sql table containing id - query - query namethe first page contains a drop down menu of all the query names. When chosen the user is sent to a page that prints the result of the query in a
Why is this function returning a false value when it shouldn't be??
This is in an include file. I want it to check a value in an html form and see if it's just white space, is numbers, is empty etc.Code: (text) [Select]<?phpfunction
convert pps to wsf with php'how?
hii want to convert with php PowerPoint file to swf file(flash)how please?thank!!!
Hit counter updating once per IP - IP HIT COUNTER
I have a hit counter, for the amount of views on a tutorial.It'll do the query and then do..$views = $row['views'] + 1;Then insert $views into the database.This updates the view for each refresh of
Send inserts to mysql thru port 80
Hi!I have an application that must do some inserts in a mysql db. This db is behind a firewall, and only port 80 is available.My first thougt is to use xml or csv, and in some way parse that using
PHP Script runs on CLI but not through web browser
I am running into an issue that I just can't seem to find the answer to. I have a Windows Server 2008 box that is running Apache 2.2.14, PHP 5.2.11, and MySQL 5.1.39. My problem is I am trying to call
