我一直在尝试编写select语句,使用companyid和customerid的组合从产品表中获取,我很确定我没有正确的方式,请帮助我编写正确的sql来使用这些参数获取。
$customerid=$_SESSION['customersid'];
$companyid=$_SESSION['companyid'];
$test="SELECT producttype,quantity FROM product WHERE username= '" . mysql_real_escape_string($customerid) . "'" . 'AND'.mysql_real_escape_string($companyid) . "'" ;
您必须将公司id的字段名放入查询
$test="SELECT producttype,quantity FROM product WHERE username= '" . mysql_real_escape_string($customerid) . "'" . 'AND COMPANYID_FIELDNAME ='.mysql_real_escape_string($companyid) . "'" ;
您的语法不正确。试试以下命令:
$customerid = mysql_real_escape_string($_SESSION['customersid']);
$companyid = mysql_real_escape_string($_SESSION['companyid']);
$test = "
SELECT producttype,quantity
FROM product
WHERE username='$customerid'
AND company='$companyid'
";
顺便说一句,您应该使用mysqli
而不是mysql
,因为它已被弃用。