using WHERE and AND clause with SQL and PHP

Question

I have been trying to write the the select statement to fetch from the products table using the combination of the companyid and customerid, I am very sure I'm not doing it the right way, kindly help me to write the right sql to fetch using these parameters.

$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) . "'" ;

If you're just learning PHP, please, do not learn the obsolete mysql_query interface. It's awful and is being removed in future versions of PHP. A modern replacement like PDO is not hard to learn. A guide like PHP The Right Way speaks to best practices. If you're serious about using PHP as a development platform there are many development frameworks like Laravel worth checking out. — tadman
– tadman, Commented Oct 13, 2015 at 19:32

Bernd Buffen · Accepted Answer · 2015-10-13 19:02:08Z

1

You must put the fieldname for the companyid in the query

$test="SELECT producttype,quantity FROM product WHERE username= '" . mysql_real_escape_string($customerid) . "'" . 'AND COMPANYID_FIELDNAME ='.mysql_real_escape_string($companyid) . "'" ;

answered Oct 13, 2015 at 19:02

Bernd Buffen

15.1k2 gold badges27 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

CodeGodie · Accepted Answer · 2015-10-13 19:12:53Z

0

your syntax is incorrect. Try the following:

 $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'
         ";

Btw, you should be using mysqli and not mysql since it is deprecated.

answered Oct 13, 2015 at 19:12

CodeGodie

12.2k6 gold badges40 silver badges66 bronze badges

Collectives™ on Stack Overflow

using WHERE and AND clause with SQL and PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related