初学php遇见的查询数据库语句出错问题占内存

 

<table cellpadding="1" cellspacing="1" border="1" align="center">
<tr>
<td width="150"><div align="center">产品</div>
</td>
<td width="150"><div align="center">数量</div>
</td>
</tr>
<?php
include_once("conn/conn.php");
$goodname=$_POST['goodname'];
$goodid=$_POST['goodid'];
if($goodname!=""&&$goodid!=""){
	$sql="select * from good_db_good where goodid='".$goodid."' and  goodname like'%".$goodname."%' ";
		$rs=mysql_query($sql);
	


	while($result=mysql_fetch_array($rs)){
		?>
        
		 <tr>
		<td width="150" ><?php echo $result['goodname'];?></td>
		<td width="150"><?php echo $result['goodnum'];?></td>
		</tr>
        <?php
	}
	}
else
if(isset($goodname)&&$goodname!=""&&$goodid==""){
	$sql="select * from good_db_good where goodname like '%".$goodname."%'";
	
	$rs=mysql_query($sql);
	


	while($result=mysql_fetch_array($rs)){
		?>
        
		 <tr>
		<td width="150" ><?php echo $result['goodname'];?></td>
		<td width="150"><?php echo $result['goodnum'];?></td>
		</tr>
        <?php
		}
	}
 else if(isset($goodid)&&$goodid!=""){
	$sql="select * from good_db_good where goodid='".$goodid."'";
	
	$rs=mysql_query($sql);
	
	while($result=mysql_fetch_array($rs)){
		?>
        
		 <tr>
		<td width="150" ><?php echo $result['goodname'];?></td>
		<td width="150"><?php echo $result['goodnum'];?></td>
		</tr>
        <?php
		}
	}
	
	
?>
</tr>
<tr><td colspan="2"><center><a href="index.php">返回菜单</a></center>
</td></tr>
</table>

上文中

$sql="select * from good_db_good where goodid='".$goodid."' and goodname like'%".$goodname."%' ";

注意引号的应用和“.”号的应用，"  ' .$goodid. ' " 和  "  '.$goodname.   ' "在代码编辑器中必须显示为特殊颜色，否则$sql就是错的，查询是就会造成占内存