CODEWITHSUNDEEP
phpmysqlconcatenation
Sohel Mansuri
Sohel Mansuri

Reputation: 564

PHP mysql_query() Select with CONCATENATION

I have the following php code:

mysql_query("SELECT a FROM b WHERE b.c = '".$_REQUEST['companyName']."'");

I also have a string:

$mynumbers = "AND b.question_code IN (1);";

How can I combine this string withing the mysql_query()?

Thanks,

Upvotes: 0

Views: 445

Answers (4)

Vinoth Babu
Vinoth Babu

Reputation: 6852

Dont use AND before Group By

Try the following code,

$query  = "SELECT a FROM b WHERE b.c = '".$_REQUEST['companyName']."'";
$query .= " GROUP BY b.question_code IN (1)"
mysql_query($query)

Upvotes: 0

Suresh Kamrushi
Suresh Kamrushi

Reputation: 16086

First is, you can not combine above two statements, the alternatively you can do like this- //Here i assume that you want to concatenate 2nd condition on particular situation so you need to add if condition or else you can directly contcate it with "." (dot) operator.

$query = "SELECT a FROM b WHERE b.c = '".$_REQUEST['companyName']."'";

if(//your condition) $query .= "AND GROUP BY b.question_code IN (1);";

mysql_query($query);

Upvotes: 0

J.K.A.
J.K.A.

Reputation: 7404

You can also do like this if you want more simplicity;

$sql="SELECT a FROM b WHERE b.c = '".$_REQUEST['companyName']."'";
$sql.=$mynumbers;

echo $sql;

Also as zerkms said your sql seems to be incorrect

Upvotes: 0

zerkms
zerkms

Reputation: 254896

mysql_query("SELECT a FROM b WHERE b.c = '".$_REQUEST['companyName']."' " . $mynumbers);

But keep in mind that AND GROUP BY all_surveys.question_code IN (1); is incorrect sql and makes no sense.

Upvotes: 1

Related Questions