Home  >  Article  >  Backend Development  >  请教以上代码哪里有有关问题

请教以上代码哪里有有关问题

WBOY
WBOYOriginal
2016-06-13 13:14:20906browse

请问以下代码哪里有问题

PHP code
<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->
<?PHP $id=$_GET['number'];

include("conn.php");

$Date = date("YmdHis");
$Filename = $Date.".csv";
$Table = isset($_GET['tid'])?$_GET['tid']:''; 
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=".$Filename);
echo "SKU,product-name,sum(quantity),\r\n";
 $Sql = "select *,sum(`quantity-purchased`) from sale_orders WHERE `number`=$id group by `jj_sku`";
 $Result = mysql_query($Sql);
 
 while($rs = mysql_fetch_array($Result) ){
 
  $j_sku=$rs['jj_sku'];
   $Sqlpr = "SELECT `product-name` FROM `product_co` WHERE `jj_sku`=$j_sku";
 $Resulta = mysql_query($Sqlpr,$conn);
 $resultaa= mysql_fetch_row($Resulta);
$pro-nm=$resultaa[0];

 echo $rs['jj_sku'].",".$pro-nm.",". $rs['sum(`quantity-purchased`)']." \r\n ";
    
 }

?>






  $Sqlpr = "SELECT `product-name` FROM `product_co` WHERE `jj_sku`=$j_sku";
 $Resulta = mysql_query($Sqlpr,$conn);
 $resultaa= mysql_fetch_row($Resulta);
$pro-nm=$resultaa[0];
我觉得以上代码有问题,请问应该怎么写呢?

------解决方案--------------------
$Sqlpr = "SELECT `product-name` FROM `product_co` WHERE `jj_sku`='$j_sku'";
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn