PHP mysql_query() Select with CONCATENATION

Question

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,

/me casts hundreds of comments about stopping using mysql_query — zerkms
– zerkms, Commented Dec 14, 2012 at 6:19

zerkms · Accepted Answer · 2012-12-14 06:18:54Z

1

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.

answered Dec 14, 2012 at 6:18

zerkms

256k73 gold badges447 silver badges551 bronze badges

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

3 Comments

Sohel Mansuri Over a year ago

just changed it. Trying it out now. Can you remove your edit?

zerkms Over a year ago

@Sohel Mansuri: can I remove what? And what exactly have you changed?

Sohel Mansuri Over a year ago

No more GROUP BY in question. In order for people to understand, you should erase your edit. :)

J.K.A. · Accepted Answer · 2012-12-14 06:24:28Z

0

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

answered Dec 14, 2012 at 6:24

J.K.A.

7,36426 gold badges100 silver badges164 bronze badges

Comments

Suresh Kamrushi · Accepted Answer · 2012-12-14 06:24:55Z

0

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);

answered Dec 14, 2012 at 6:24

Suresh Kamrushi

16.2k13 gold badges79 silver badges93 bronze badges

Comments

Vinoth Babu · Accepted Answer · 2012-12-14 06:32:52Z

0

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)

answered Dec 14, 2012 at 6:32

Vinoth Babu

6,82510 gold badges40 silver badges56 bronze badges

Collectives™ on Stack Overflow

PHP mysql_query() Select with CONCATENATION

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related