Code: Select all
$fp=fopen($file,w);
$heading="E - Mail,First Name,Last Name,Company Name,Address1,Address2,City,State,Country,Zip Code,Website,Phone,Title,Title Level"."\n";
fwrite($fp,$heading);
$selected = explode('a', $ids);
for($i=0;$i<(count($selected)-1);$i++)
{
if($selected[$i]!="")
{
$sel_query2 = mysql_query("select email from cart where id='".$selected[$i]."'");
while($row2 = mysql_fetch_assoc($sel_query2))
{
$email=$row2["email"];
$sel_query1 = mysql_query("select * from contacts where email='".$email."'");
while($row1 = mysql_fetch_assoc($sel_query1))
{
$data=$row1["email"].','.$row1["fname"].','.$row1["lname"].','.$row1["cname"].','.trim($row1["cadd1"]).','.trim($row1["cadd2"]).','.$row1["city"].','. $row1["state"].','. $row1["ctry"].','.$row1["zip"].','. $row1["web"].','. $row["phone"].','.$row1["title"].','.$row1["level"]."\n";
fwrite($fp,$data);
}
}
}
}
fclose($fp);
$f=$fn.".csv";
Thanks in advance