new at PHP... major work project am lost

techogurl

I've never done PHP before in my life. I just got handed a PHP and a MySql book to do a project that needs to be done by tommorrow. I've looked at the code and can understand what is going on, but haven't the slightest idea on how or even where to get started as I've no real reference point. I've been told how awesome everyone here is...please help me.

Basically I need to create some PHP code that will work with MySQL to add a field called route_datetime to a table claims. Then I need to process a field called claimStatusUpdate and when that is equal to "r" I need to compile a list of what is past 7 days. The output for the list isn't important, but I would think that the ability to print that list and see that list would be.

I believe that I can use

ALTER TABLE claims ADD route_datetime

to add the column and

SELECT * FROM claims WHERE claimstatusupdate = "r"
if ($route_datetime <= updated_datetime-7) {
do something
}

do I need to use mktime() for conversion or gregoriantojd()?

Would appreciate any help.

rehfeld

have you done any programming/scripting before?

techogurl

Yes, I have programmed in C++, VB, COBOL, and HTML. It's been a few years though so not only am I rusty...I'm attempting to learn a new language at the same time.

techogurl

Can any one tell me if I'm heading in the correct direction?

This is what I have currently:

ALTER TABLE claims ADD COLUMN route_datetime datetime;

$diff_date = gregoriantojd($date1mo, $date1dy, $date1yr) -
gregoriantojd($date2mo, $date2dy, $date2yr);

function CheckForFileInClaimImageDb($tblClaims, $testfile)
{
while ($recordset = mysql_query("SELECT * FROM claims WHERE claimstatusupdate = "r")😉

if ($diff_date >= 7) {
echo " ROUTED CLAIMS NEEDING IMMEDIATE ATTENTION \n";
echo "claimnum"
}
echo "End of Script: checkclaimfiles.php\n";
exit;