Variable scope question?

[adam525]

I have some code that someone else wrote and I'm trying to fix it.

SNIP

  if ($x == ADMINRETURN){
      $closefile = TRUE;
      $countit = 0;
      #$dodate = mysql_query("UPDATE ADMINRETURN SET procdate = '{$conarrepdate}' WHERE procdate = '{$arrepdate}'");
      while ($data = fgetcsv($myFile, 2048, $delimiter)){
            $armid = $data[$fieldArray[1][1]];

            $arrepdate = $data[$fieldArray[14][1]];
            global $conarrepdate;
            $conarrepdate = convert_date($data[$fieldArray[14][1]]);
            $dodate = mysql_query("UPDATE ADMINRETURN SET procdate = '{$conarrepdate}' WHERE procdate = '{$arrepdate}'");
            }

            $qstring = "SELECT ADMINRETURN.creditnumber FROM ADMINRETURN LEFT JOIN PROFIT ON ADMINRETURN.creditnumber = PROFIT.mid AND ADMINRETURN.procdate = '{$conarrepdate}'
                            AND PROFIT.mid IS NULL GROUP BY ADMINRETURN.creditnumber";
            $diff = mysql_query($qstring);

                while ($cdata = mysql_fetch_array($diff)){
                    $adminmid = $cdata['creditnumber'];
                    $admindate = $cdata['procdate'];
                    echo $conarrepdate;
                    $profitupdate = mysql_query("INSERT INTO PROFIT (mid,ReportDate) VALUES ('{$adminmid}','{$conarrepdate}')");

SNIP

The $conarrepdate variable works until the last line where it says $profitupdate = mysql_query("INSERT INTO ......

I get all 0's. I want the date formatted the way that I'm getting the 0's, I just want the date. I get the full date every time above when I use that var.

Thanks,

Adam

[Weedpacket]

Please use [php]...[/php] tags around PHP code.

All I can see is that $conarrepdate won't have a value if $x!=ADMINRETURN.

[halojoy]

Weedpacket wrote:

Please use

...

tags around PHP code.

All I can see is that $conarrepdate won't have a value if $x!=ADMINRETURN.

Weedpacket, one of the most exprienced PHP Helpers

Weedpacket

Join Date: Aug 2002
Location: Unseen University
Posts: 16,253

is probably right on both points:

1. you should use our special [ php ] your code [ /php ]
   will give us a better chance to help you with a quick answer

2. if ($x = ADMINRETURN) would give ...zero results
   if ADMINRETURN is NOT

here is your code with bbcode php-tags around
... in colors ... so us helpers get an easier job/task .. when want to Help You

if ($x == ADMINRETURN){

$closefile = TRUE;
$countit = 0;
#$dodate = mysql_query("UPDATE ADMINRETURN SET procdate = '{$conarrepdate}' WHERE procdate = '{$arrepdate}'");
while ($data = fgetcsv($myFile, 2048, $delimiter)){
$armid = $data[$fieldArray[1][1]];

$arrepdate = $data[$fieldArray[14][1]];
global $conarrepdate;
$conarrepdate = convert_date($data[$fieldArray[14][1]]);
$dodate = mysql_query("UPDATE ADMINRETURN SET procdate = '{$conarrepdate}' WHERE procdate = '{$arrepdate}'");
}

$qstring = "SELECT ADMINRETURN.creditnumber FROM ADMINRETURN LEFT JOIN PROFIT ON ADMINRETURN.creditnumber = PROFIT.mid AND ADMINRETURN.procdate = '{$conarrepdate}'
AND PROFIT.mid IS NULL GROUP BY ADMINRETURN.creditnumber";
$diff = mysql_query($qstring);

while ($cdata = mysql_fetch_array($diff)){
$adminmid = $cdata['creditnumber'];
$admindate = $cdata['procdate'];
echo $conarrepdate;
$profitupdate = mysql_query("INSERT INTO PROFIT (mid,ReportDate) VALUES ('{$adminmid}','{$conarrepdate}')");

} // ens if($x == ADMINRETURN)  

regars 🙂
your halojoy .. only want to help, if can

[adam525]

OK,

The code returns a date for this part of the code...

This part of the statement - "UPDATE ADMINRETURN SET procdate = '{$conarrepdate}' > conarrepdate returns 2008-01-31

if ($x == ADMINRETURN){
$closefile = TRUE;
$countit = 0;
#$dodate = mysql_query("UPDATE ADMINRETURN SET procdate = '{$conarrepdate}' WHERE procdate = '{$arrepdate}'");
while ($data = fgetcsv($myFile, 2048, $delimiter)){
$armid = $data[$fieldArray[1][1]];

$arrepdate = $data[$fieldArray[14][1]];
global $conarrepdate;
$conarrepdate = convert_date($data[$fieldArray[14][1]]);
$dodate = mysql_query("UPDATE ADMINRETURN SET procdate = '{$conarrepdate}' WHERE procdate = '{$arrepdate}'");
}

$qstring = "SELECT ADMINRETURN.creditnumber FROM ADMINRETURN LEFT JOIN PROFIT ON ADMINRETURN.creditnumber = PROFIT.mid AND ADMINRETURN.procdate = '{$conarrepdate}'
AND PROFIT.mid IS NULL GROUP BY ADMINRETURN.creditnumber";
$diff = mysql_query($qstring);

but on this part, it only returns 0000-00-00

while ($cdata = mysql_fetch_array($diff)){
$adminmid = $cdata['creditnumber'];
$admindate = $cdata['procdate'];
echo $conarrepdate;
$profitupdate = mysql_query("INSERT INTO PROFIT (mid,ReportDate) VALUES ('{$adminmid}','{$conarrepdate}')");

The INSERT INTO PROFIT inserts 0000-00-00

It's as if the variable is empty after the first while loop...

Thanks again,

Adam