Need Do While Loop Fix

kennym

The table display generated by the code below should repeat the table row for each agent.

If I don't use the includes, it seems to run okay, but the minute I use the includes it stops the loop.

I'll paste the code, and the html output.

MANY MANY THANKS AND GURU PROPS TO WHOEVER CAN HELP!

Here's the code:

<?php

###################################################################################

Let's get the security settings out of the way

These variables allow you to connect to the mySQL database.

We'll assign them variables so that we don't have to keep repeating it throughout the script.

If you would like to change it you can, but it seems a bit redundant

###################################################################################

IP Address

$sqlip = "localhost";

mySQL Username

$user = "SERV";

mySQL Password

$pw = "*********";

Database Name

$db = "atwtx ";
###########################END SECURITY VARIABLE ASSIGNMENTS#######################

echo "<table border='0' cellspacing='0' id='AutoNumber1' bordercolor='#C0C0C0' cellpadding='0' align='center'>";
echo "<tr>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  Agent Station  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  Agent Name  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  Start Call  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  End Call  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  Total Calls  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  SA  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  CB  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  AM  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  AM-X  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  CP  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  DX  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  FX/PG  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  AH  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  NA  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  NI  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  DNC  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  PM  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  TA  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  Busy  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  NQ  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>  CPH  </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'> </td>";
echo "</tr>";

###########################LET'S GET SOME SAMPLE RESULTS###########################
$mysql_access = mysql_connect($sqlip, $user, $pw);
mysql_select_db($db, $mysql_access) or die("Cannot connect to the database. " . mysql_error());
$query = "SELECT * FROM agentlogfiles WHERE id >'0' Group By agentstation ORDER BY id" or die("No Records Found... " . mysql_error());
$result = mysql_query($query, $mysql_access);
while($row = mysql_fetch_row($result))
{
do
{
echo "<tr>";
$agentstationid=$row[7];
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>$agentstationid</td>";

echo "<td style='border-style: solid; border-width: 1' nowrap align='center'><b><font size='1' face='Arial'>Name</font></b></td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'><b><font size='1' face='Arial'>";
echo $row[8];
echo ':';
echo $row[9];
echo ':';
echo $row[10];
echo "</font></b></td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'><b><font size='1' face='Arial'>End</font></b></td>";
include ("agent_logfiles_total_call_count_inc.php");
$dispositionid='HangUp-SA';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-CB';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-AM';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-AM LM - C-OMB-Misc-AMMsg1.wav';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-CP';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-DX';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-FX/PG';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-Human';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-NA';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-NI';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-NO CALLS';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-PM';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-TA';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-Busy';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-NQ';
include 'agent_logfiles_report_agent_sort_inc.php';
echo "</font></b></td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>&nbsp;</td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>&nbsp;</tr>";

}
while($row = mysql_fetch_row($result));
}
echo '</table>';
?>

Thanks in advance!

kevinsequeira

why do u have a do-while loop inside a while loop ??
just have the while loop thats all

while($row = mysql_fetch_row($result)){
 echo "<tr>";
$agentstationid=$row[7];
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'><b><font size='1' face='Arial'>$agentstationid</font></b></td>";

echo "<td style='border-style: solid; border-width: 1' nowrap align='center'><b><font size='1' face='Arial'>Name</font></b></td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'><b><font size='1' face='Arial'>";
echo $row[8];
echo ':';
echo $row[9];
echo ':';
echo $row[10];
echo "</font></b></td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'><b><font size='1' face='Arial'>End</font></b></td>";
include ("agent_logfiles_total_call_count_inc.php");
$dispositionid='HangUp-SA';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-CB';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-AM';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-AM LM - C-OMB-Misc-AMMsg1.wav';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-CP';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-DX';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-FX/PG';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-Human';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-NA';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-NI';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-NO CALLS';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-PM';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-TA';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-Busy';
include 'agent_logfiles_report_agent_sort_inc.php';
$dispositionid='HangUp-NQ';
include 'agent_logfiles_report_agent_sort_inc.php';
echo "</font></b></td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'> </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'> </tr>";
}

reg
kevin

kennym

Here's the code, reposted, with the include files hard coded into the script.

I've eliminated enough of the middle portion of the code so that the forum will allow me to post it with less than 10k characters.

Thanks.

<?php

###################################################################################

Let's get the security settings out of the way

These variables allow you to connect to the mySQL database.

We'll assign them variables so that we don't have to keep repeating it throughout the script.

If you would like to change it you can, but it seems a bit redundant

###################################################################################

IP Address

$sqlip = "localhost";

mySQL Username

$user = "SERV";

mySQL Password

$pw = "*******";

Database Name

$db = "atwtx ";
###########################END SECURITY VARIABLE ASSIGNMENTS#######################

###########################LET'S GET SOME SAMPLE RESULTS###########################
$mysql_access = mysql_connect($sqlip, $user, $pw);
mysql_select_db($db, $mysql_access) or die("Cannot connect to the database. " . mysql_error());
$query = "SELECT * FROM agentlogfiles WHERE id >'0' Group By agentstation ORDER BY id" or die("No Records Found... " . mysql_error());
$result = mysql_query($query, $mysql_access);
while($row = mysql_fetch_row($result))
{
echo "<tr>";
$agentstationid=$row[7];
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>$agentstationid</td>";

echo "<td style='border-style: solid; border-width: 1' nowrap align='center'><b><font size='1' face='Arial'>Name</font></b></td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'><b><font size='1' face='Arial'>";
echo $row[8];
echo ':';
echo $row[9];
echo ':';
echo $row[10];
echo "</font></b></td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'><b><font size='1' face='Arial'>End</font></b></td>";
include ("agent_logfiles_total_call_count_inc.php");

###########################LET'S GET SALE RESULTS###########################
$mysql_access = mysql_connect($sqlip, $user, $pw);
mysql_select_db($db, $mysql_access) or die("Cannot connect to the database. " . mysql_error());
$query = "SELECT * FROM agentlogfiles WHERE disposition = 'HangUp-SA' AND agentstation='$agentstationid' " or die("No Records Found... " . mysql_error());
$result = mysql_query($query, $mysql_access);
$rowcount='-1';
do
{
$rowcount=($rowcount+1);
}
while($row = mysql_fetch_row($result));
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>";
echo "";
echo $rowcount;
echo "</td>";
###########################END SALE RESULTS###########################

###########################LET'S GET CALLBACK RESULTS###########################
$mysql_access = mysql_connect($sqlip, $user, $pw);
mysql_select_db($db, $mysql_access) or die("Cannot connect to the database. " . mysql_error());
$query = "SELECT * FROM agentlogfiles WHERE disposition = 'HangUp-CB' AND agentstation='$agentstationid' " or die("No Records Found... " . mysql_error());
$result = mysql_query($query, $mysql_access);
$rowcount='-1';
do
{
$rowcount=($rowcount+1);
}
while($row = mysql_fetch_row($result));
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>";
echo "";
echo $rowcount;
echo "</td>";
###########################END CALLBACK RESULTS###########################

###########################LET'S GET ANSWERING MACHING (NO MSG) RESULTS###########################
$mysql_access = mysql_connect($sqlip, $user, $pw);
mysql_select_db($db, $mysql_access) or die("Cannot connect to the database. " . mysql_error());
$query = "SELECT * FROM agentlogfiles WHERE disposition = 'HangUp-AM' AND agentstation='$agentstationid' " or die("No Records Found... " . mysql_error());
$result = mysql_query($query, $mysql_access);
$rowcount='-1';
do
{
$rowcount=($rowcount+1);
}
while($row = mysql_fetch_row($result));
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>";
echo "";
echo $rowcount;
echo "</td>";
###########################END ANSWERING MACHINE (NO MSG) RESULTS###########################

###########################LET'S GET ANSWERING MACHINE (LEAVE MSG) RESULTS###########################
$mysql_access = mysql_connect($sqlip, $user, $pw);
mysql_select_db($db, $mysql_access) or die("Cannot connect to the database. " . mysql_error());
$query = "SELECT * FROM agentlogfiles WHERE disposition = 'HangUp-AM LM - C-OMB-Misc-AMMsg1.wav' AND agentstation='$agentstationid' " or die("No Records Found... " . mysql_error());
$result = mysql_query($query, $mysql_access);
$rowcount='-1';
do
{
$rowcount=($rowcount+1);
}
while($row = mysql_fetch_row($result));
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'>";
echo "";
echo $rowcount;
echo "</td>";
###########################END ANSWERING MACHINE (LEAVE MSG) RESULTS###########################
echo "</td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'> </td>";
echo "<td style='border-style: solid; border-width: 1' nowrap align='center'> </tr>";
}
echo '</table>';
?>