Below is what I have so far. I can retrieve the data I need it, but how do I
sort it like I did in the original?
[PHP]
<TITLE>.: PHP/MySQL Testing :.</TITLE>
<STYLE TYPE="text/css">
h3 {font-family: Verdana, Arial, Helvetica, sans-serif}
font.font {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: x-small;
}
</STYLE>
<H3>Connecting to Database and Tables</H3>
<PRE>
<FONT CLASS="font">
<?php
$username = "####t";$password = "####";$hostname = "####";
mysql_connect($hostname, $username, $password) or die("Unable to connect to
MySQL");print "Connected to MySQL <br>";mysql_select_db("database");print
"Connected to Database";
?>
</FONT>
<H3>Fetching Carers Arrays</H3>
<FONT CLASS="font"><?
$result = mysql_query("SELECT name, hours, remaining FROM carers");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{printf ("Name: %s Hours: %s Remaining: %s<BR>", $row["name"],
$row["hours"], $row["remaining"]);}
?>
</FONT>
<H3>Fetching Clients Arrays</H3>
<FONT CLASS="font"><?
$result = mysql_query("SELECT name, hours FROM clients");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{printf ("Name: %s Hours: %s<BR>", $row["name"], $row["hours"]);}
?>
</FONT>
<H3>Original Output</H3>
<FONT CLASS="font">
<?php
$carers = array(
array('name' => 'Carer 01', 'hours' => 10, 'remaining' => 10),
array('name' => 'Carer 02', 'hours' => 12, 'remaining' => 12),
);
$clients = array(
array('name' => 'Client 01', 'hours' => 2),
array('name' => 'Client 02', 'hours' => 3),
array('name' => 'Client 03', 'hours' => 4),
array('name' => 'Client 04', 'hours' => 1),
array('name' => 'Client 05', 'hours' => 2),
array('name' => 'Client 06', 'hours' => 5),
array('name' => 'Client 07', 'hours' => 4),
array('name' => 'Client 08', 'hours' => 2),
array('name' => 'Client 09', 'hours' => 2),
);
$carer_num = 0;
for ($i=0; $i<count($clients); $i++) {
$row = $clients[$i];
// If current carer doesn't have enough hours left, move to the next
while ($carer_num < count($carers) && $row['hours'] >
$carers[$carer_num]['remaining'])
$carer_num++;
// No more carers
if ($carer_num == count($carers)) {
break;
}
// Allocate time
$allocated_hours = min($carers[$carer_num]['remaining'], $row['hours']);
$carers[$carer_num]['clients'][] = array('client' => $row['name'],
'hours' => $allocated_hours);
$carers[$carer_num]['remaining'] -= $allocated_hours;
}
print_r($carers);
?>
</FONT>
<HR ALIGN="LEFT" WIDTH="50%">
<H3>Better Output</H3>
<FONT CLASS="font">
<?php foreach ($carers as $carer)
{ ?>
<BR><STRONG>Name:</STRONG> <BR><UL><LI><?php echo $carer['name']?>
</LI></UL>
<P><STRONG>Hours Allowed:</STRONG><BR><UL><LI><?php echo
$carer['hours']?></LI></UL>
<P><STRONG>Remaining Hours:</STRONG><BR><UL><LI><?php echo
$carer['remaining']?></LI></UL>
<P><STRONG>Clients:</STRONG>
<?php foreach ($carer['clients'] as $client)
{
echo "<UL><LI>{$client['client']} : {$client['hours']} Hours
<br></LI></UL>";
}
echo "<BR><HR align=left WIDTH=25%>";
}
?>
</FONT>
</PRE>
[/PHP
