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?
RTF fomatting to email content
Im trying to sen an email with content is picked up from a rtf-file (file_get_contents('*.rtf'). Mail is sent correctly, but the formatting of the content includes rtf formatting like:
Java API in PHP?
I have an application that we use internally here at the office.The software company provides a Java API.Is there a way to use this Java API with PHP?or am i stuck having to use tomcat and jsp to
Limiting uploaded file type
Hi. First post here I am working on a simple upload script, and I need it to limit the allowed file type that is uploaded to only .mpr files. .mpr files are not a MIME file type so I do not know how
How can you detect variable string in a massive string?
Ok guys, i need some help with this one.I am going to be getting a large string, like 10-20 paragraphs. I will also have an array or words that i would like to search it for.
Converting RGB values to HEX
Code: <?PHP$file_handle = fopen("colors/rgb.csv", "r");while (!feof($file_handle) ) {$line_of_text = fgetcsv($file_handle, 1024);print $line_of_text[2] . $line_of_text[3] .
xApp Analytics in BI 7.0
Dear all,
Blocking video streaming
Hello everyone,I post a message here because i didn't find any solution yet.I just finished video streaming service on my website. I use xmoov script (http://xmoov.com/xmoov-php/) to do that. It works
SMTP server...
I recently found a tutorial online on SMTP authentification for sending emails from webpages, here is the tutorial
Help a newbee save my job !
Hey guys i am dying here i am new to php and would like for someone to help me with this problemi have a script that send information from a "form" but the probelm is that i need this to be
Using mysql_real_escape_string for displayed content
On my website users can input data into a textarea and it will store it in the mysql database. But, I am unsure on how to prevent against mysql injections without using mysql_real_escape_string since