PHP - Keep 1 Record At Top In While Loop

Ok, i've driven myself mad trying to figure this out. While I'm new at php I really think this should work. Could someone look at this and point me in the right direction?   

Ok background info: 

I have three tables  that I'm selecting from. I want to find the records in TABLE A that match these three criteria and "Join" per say.  the SELECT does exactly what I want and works.  My issue is when I try to LOOP through and pull certain information make adjustments in other tables Table C.. it only adjust as if it's gone through ONLY one loop. It will only do last record.  I want it to loop through the records it's found and Update the field in Table C to the balance of TABLE C + TABLE B price. Then update TABLE A with a value of 1 and LOOP and do it again until all records found in the original select are done.

CODE:

Code: [Select]
require_once ('./includes/config.inc.php');



$query = "SELECT
table_a.id,
table_a.table_b_id,
table_a.user_id,
table_a.unit_returned,
table_b.id,
table_b.title,
table_b.price,
table_b.closed,
table_c.id,
table_c.nick,
table_c.balance

FROM
table_a, table_b, table_c
     
WHERE
table_a.unit_returned= 0
AND table_b.closed = 1
AND table_b.id = table_a.table_b_id
AND table_c.id = table_a.user_id ";

 

$result = mysql_query($query);
$num = mysql_num_rows($result);
  echo "<table border='1'>";
   
 
   
   while ($row = mysql_fetch_array($result, MYSQL_NUM))
   
   {
      echo "<tr><td>$row[0]</td><td>$row[1]</td><td>$row[2]</td><td>$row[3]</td><td>$row[4]</td><td>$row[5]</td><td>$row[6]</td><td>$row[7]</td><td>$row[8]</td><td>$row[9]</td><td>$row[10]</td></tr>";

$newbalance = $row[6];
                                $newbalance2 =$row[10];
                                $finalbalance = $newbalance+$newbalance2;
$userid = $row[2];
$signid = $row[0];

echo "$newbalance". " $newbalance2" . " $finalbalance"."<br>". "$userid ". "<br>"."$signid"."<br>";

$query = "table_c SET balance=".$finalbalance." WHERE id=" .$userid ;
$result = mysql_query($query);
                               

}

$query = "UPDATE table_a SET unit_returned=1"; //   THIS I WANT TO DO TO ALL RECORDS AS I LOOP AS WELL or at the end seeing as above should find all the records anyways. wouldn't matter to me.
$result = mysql_query($query);

ANY HELP WOULD BE GREATLY APPRECIATED


THANKS!!!! so MUCH!

I have a php script defined that parsed the xml file and runs through the 1st record - encased within the EOF tags.
However, I need to capture ALL records - each defined between "EOF" tags - of the select xml file that will be pass to the script.

Currently, the php script I have finds the 1st set of info from the xml file but doesn't loop through the remaining records which all encased between the "EOF" tags. I know I need a while loop but not sure on the syntax to get it through the remaining files. Any comments appreciated to help edit code to form the required loop:


$xml = simplexml_load_file($new_location);
        foreach($xml->EOF as $eof) {
             $autoNoT  = $eof->AutoNo;
             $vegregnoT = $eof->TruckNo; 
             $clientIDT  = $eof->ClientID;
}


Here's the example xml file which contains multiple records that I need to extract each set of date between the <EOF></EOF> tags.
Note: the above php code extract just the 1st record then stops (I know I'm missing the loop but need help defining it...)

Code: [Select]
- <DocumentElement>
- <EOF>
  <AutoNo>109531</AutoNo>
  <TruckNo>XLX885GP</TruckNo>
  <ClientID>3</ClientID>
  </EOF>
- <EOF>
  <AutoNo>109532</AutoNo>
  <TruckNo>ZFN726GP</TruckNo>
  <ClientID>3</ClientID>
  </EOF>
- <EOF>
  <AutoNo>109533</AutoNo>
  <TruckNo>ZFP113GP</TruckNo>
  <ClientID>3</ClientID>
  </EOF>
- <EOF>
  <AutoNo>109534</AutoNo>
  <TruckNo>WSG299GP</TruckNo>
  <ClientID>3</ClientID>
  </EOF>
- <EOF>
  <AutoNo>109872</AutoNo>
  <TruckNo>XKR493GP</TruckNo>
  <ClientID>3</ClientID>
  </EOF>
</DocumentElement>

Hey everyone, I've just undertaken my first PHP project and I'm trying to build an HTML table that lists businesses by category.  The problem I am having is that the output of the PHP shows the first record in the first row both columns and this happens with every record after that.

The Code:
<?php



  // Set the error(s) reporting level

   error_reporting(E_ALL);

   ini_set("display_errors", 1);

   $category = "Professional Services";

   

   // Open a connection link to your Database Engine

   $link = mysql_connect('localhost', 'liecon63_bizdir', 'pass') or die("Connection Error : " . mysql_error());



   // Select the database to work with

   mysql_select_db('liecon63_bizdir') or die("Database Selection Error : " . mysql_error());



   // Define your query

   $sqlquery = "SELECT * FROM bizdir WHERE bizcategory = '".$category."'"; 



   // Execute the query (returning a result set in this case

   $sqlresult = mysql_query($sqlquery) or die("Query Error : " . $sqlquery . "<br /> Error: " . mysql_error());



   // Validate that the query returned records

   if (mysql_num_rows($sqlresult) > 0) {

     // Start display of the records

     echo "Business Category : " . $category . "<BR />";

     echo "<table>";

     // Loop through your result set to process the results

     while ($row = mysql_fetch_array($sqlresult, MYSQL_ASSOC))  // here you can simply use mysql_fetch_assoc() instead

     {

        // Process your records here... like

?><table border="0" width="100%" id="table3">

  <td width="400"><tr>

        <td><?php echo $row['bizname']; ?>

<br>

<?php echo $row['bizaddress']; ?>

<br>

<?php echo $row['bizcity']; ?>, <?php echo $row['bizstate']; ?> <?php echo $row['bizzip']; ?>

<br>

<?php echo $row['bizphone']; ?></td>

<td><?php echo $row['bizname']; ?>

<br>

<?php echo $row['bizaddress']; ?>

<br>

<?php echo $row['bizcity']; ?>, <?php echo $row['bizstate']; ?> <?php echo $row['bizzip']; ?>

<br>

<?php echo $row['bizphone']; ?></td>

      </tr>

  </table>

  <?

     }

     echo "</table>";

  } else {

     echo "No records have been found for the category " . $category;

  }

// Close your Db Engine Link

mysql_close($link);

?>

The Output:
<BODY onLoad="changeBkg()" id="body" TEXT="#000000" LINK="#FF0000" ALINK="#FF0000" VLINK="#FF0000">
Business Category : Professional Services<BR /><table><table border="0" width="100%" id="table3">
  <td width="400"><tr>
        <td>Blumstein Accounting <br>
1476 Blue Spruce Lane <br>
Wantagh, New York 11793 <br>
(516) 221-6161</td>
<td>Blumstein Accounting <br>
1476 Blue Spruce Lane <br>
Wantagh, New York 11793 <br>
(516) 221-6161</td>
      </tr>
  </table>
  <table border="0" width="100%" id="table3">
  <td width="400"><tr>
        <td>Sachem Dental Group <br>
470 Patchogue Holbrook Rd <br>
Holbrook, New York 11741 <br>
(631) 589-8485</td>
<td>Sachem Dental Group <br>
470 Patchogue Holbrook Rd <br>
Holbrook, New York 11741 <br>
(631) 589-8485</td>
      </tr>
  </table>
  <table border="0" width="100%" id="table3">
  <td width="400"><tr>
        <td>Care Plus Chiropractic <br>
1150 Sunrise Highway <br>
Bayshore, New York 11706 <br>
(631) 665-1150</td>
<td>Care Plus Chiropractic <br>
1150 Sunrise Highway <br>
Bayshore, New York 11706 <br>
(631) 665-1150</td>
      </tr>
  </table>
  </table></html>

Please HELP!

Hey.   So the issue I'm having is consecutive loops on semi-large arrays, over and over. Consider this array:

$firstArray = array(
'row1' => array(
'dates' => array(
'2014-01-01' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-02' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-03' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-04' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-05' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-06' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-01-07' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
)
),
'row2' => array(
'dates' => array(
'2014-02-01' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-02' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-03' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-04' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-05' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-06' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-07' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-08' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
'2014-02-09' => array('key1' => 'value1', 'key2' => 'value2', 'key3' => 'value3', 'key4' => 'value4', 'key5' => 'value5', 'key6' => 'value6', 'key7' => 'value7', 'key8' => 'value8', 'key9' => 'value9', 'key10' => 'value10'),
)
)
);

Originally the data comes from ~2-3 database tables, of course. But to ilustrate the point, this is how the main array looks like. This array usually contains anywhere between 10-50 rows, each row containing at least 10 dates, with 10 key/values each.   And after setting up all the data, it needs to be processed. Currently this is how a friend of mine did it..

$placeDataHere = array();
foreach($firstArray as $key => $dates) {
foreach($dates as $date => $values) {
foreach($values as $key => $value) {
$placeDataHere['DV_' . $date]['SM_' . $key] = 'KS_' . $value;
//Followed by another ~50-70 lines of processing the 3 loop's data..
...
...
....
....
....
....
....
....
}
}
}

Obviously this isn't good practise, but we can't seem to figure out a better way of doing it, since both the data and the loops are horribly nested.   This loop and setup of $firstArray is run anywhere between 10-20 times/request, due to amount of users we wish to process. So, the result is that this code can take up to over 2-3 minutes to complete, which isn't really optimal performance.   In short my question is, are there any better methods of handling this with the data setup we currently have?

Below is my output on the browser:

    Student: Kevin Smith (u0867587)
    Course: INFO101 - Bsc Information Communication Technology Course Mark 70 Grade
    Year: 3
   
   
    Module: CHI2550 - Modern Database Applications Module Mark: 41 Mark Percentage: 68 Grade: B
   
    Session: AAB Session Mark: 72 Session Weight Contribution 20%
   
    Session: AAE Session Mark: 67 Session Weight Contribution 40%


    Module: CHI2513 - Systems Strategy Module Mark: 31 Mark Percentage: 62 Grade: B
   
    Session: AAD Session Mark: 61 Session Weight Contribution 50%

Now where it says course mark above it says 70. This is incorrect as it should be 65 (The average between the module marks percentage should be 65 in the example above) but for some stange reason I can get the answer 65. I have a variable called $courseMark and that does the calculation. Now if the $courseMark is echo outside the where loop, then it will equal 65 but if it is put in while loop where I want the variable to be displayed, then it adds up to 70. Why does it do this.
   
    Below is the code:

Code: [Select]
    $sessionMark = 0;
    $sessionWeight = 0;
    $courseMark = 0;
   
    $output = "";
   
    $studentId = false;
    $courseId  = false;
    $moduleId  = false;
   
    while ($row = mysql_fetch_array($result))
    {
   
   
    $sessionMark += round($row['Mark'] / 100 * $row['SessionWeight']);
    $sessionWeight  += ($row['SessionWeight']);
        $courseMark = ($sessionMark /  $sessionWeight * 100);
   
          if($studentId != $row['StudentUsername'])
        {
   
            //Student has changed
            $studentId = $row['StudentUsername'];
   
            $output .= "<p><strong>Student:</strong> {$row['StudentForename']} {$row['StudentSurname']} ({$row['StudentUsername']})\n";
   
        }
             
        if($courseId != $row['CourseId'])
        {
   
            //Course has changed
            $courseId = $row['CourseId'];
   
            $output .= "<br><strong>Course:</strong> {$row['CourseId']} - {$row['CourseName']} <strong>Course Mark</strong>" round($courseMark) "<strong>Grade</strong>  <br><strong>Year:</strong> {$row['Year']}</p>\n";
   
        }
   
        if($moduleId != $row['ModuleId'])
        {
   
            //Module has changed
            if(isset($sessionsAry)) //Don't run function for first record
            {
   
                //Get output for last module and sessions
                $output .= outputModule($moduleId, $moduleName, $sessionsAry);
            }
   
            //Reset sessions data array and Set values for new module
   
            $sessionsAry = array();
            $moduleId    = $row['ModuleId'];
            $moduleName  = $row['ModuleName'];
        }
             
        //Add session data to array for current module
             
        $sessionsAry[] = array('SessionId'=>$row['SessionId'], 'Mark'=>$row['Mark'], 'SessionWeight'=>$row['SessionWeight']);
             
    }    //Get output for last module
   
    $output .= outputModule($moduleId, $moduleName, $sessionsAry);
   
    //Display the output
    echo $output;
I think the problem is that it is outputting the answer of the calculation only for the first session mark. How in the while loop can I do it so it doesn't display it for the first mark only but for all the session marks so that it ends up showing the correct answer 65 and not 72?