Hi
I have some data that i display on screen and i need to be able to export to excel as is. Whatever i have found online only refers to data in a single table but my sql statement is of joins. I am searching for a simple way to do this using this code below. Would very much appreciate some help. thanks. anandis
$OR = " SELECT * FROM address a LEFT JOIN Cities USING(CITYID) JOIN Customers c USING(CID) WHERE a.SID = '$sid' ORDER BY c.`Company` asc, `CITYID` asc ";
$resultOR = mysqli_query($link2, $OR) or die(mysqli_errorno());
$numofrows = mysqli_num_rows($resultOR);
echo "<table border='1' style='border-collapse: collapse' bordercolor='#111111' width='100%'>\n";
echo "<tr bgcolor='#FFEAED'>
<td><b><font size=3 face=Calibri color=brown>S.No</b></td>
<td><b><font size=3 face=Calibri color=brown>CAID</b></td>
<td><b><font size=3 face=Calibri color=brown>CID</b></td>
<td><b><font size=3 face=Calibri color=brown>Company</b></td>
<td><b><font size=3 face=Calibri color=brown>Street</b></td>
ETC
\n";
for ($p = 1; $p <= $numofrows; $p++) {
$myrow = mysqli_fetch_array($resultOR);
$caid = $myrow["CAID"];
$cid = $myrow["CID"];
$cityid= $myrow['CITYID'];
$result2 = mysqli_query($link2, "SELECT * FROM Cities WHERE `CITYID` = '$cityid' ");
$myrow2 = mysqli_fetch_array($result2);
$city = $myrow2["City"];
$sql22 = "SELECT * FROM Customers WHERE `CID` = '$cid' ";
$result22 = mysqli_query($link2, $sql22) or die (mysqli_errorno ());
$myrow22=mysqli_fetch_array($result22);
$company = $myrow22["Company"];
if ($p % 2) { //this means if there is a remainder
echo "<TR bgcolor=\"#FAF0F0\">\n";
} else { //if there isn't a remainder we will do the else
echo "<TR bgcolor=\"white\">\n";
}
echo "
<td><font face=\"Calibri\" size=\"3\" color=\"brown\">$p </TD>
<td><font face=\"Calibri\" size=\"3\" color=\"brown\">$city </TD>
<td><font face=\"Calibri\" size=\"3\" color=\"brown\">$cid </TD>
<td><font face=\"Calibri\" size=\"3\" color=\"brown\">$company</TD>
<td><font face=\"Calibri\" size=\"3\" color=\"brown\">" . $myrow["Street"] . " </TD>
echo "</TR>\n";
}
echo "</TABLE>\n";