SELECT

[andy_b_1502]

Hi everyone! 

 

I need to know how to write two $what_services variables in so it looks for both "R" AND "B"..

 

R and B are values within my db table, here's the code:

 

<?php
$what_services = "R";

    $query = "SELECT * FROM companies WHERE what_services = '$what_services' ORDER BY approved DESC, company_name ASC";
$result = mysql_query($query); ?>

 

iv'e tried the following but have gotten undesired results:

 

two what services like so;

 

$what_services = "R";

$what_services = "B";

 

separating with comma's;

 

$what_services = "R, B";

 

Using AND;

 

$what_services = "R AND B";

 

None of which works, what is the correct way to write this?

 

Thanks

[Kristoff1875]

Try

 

what_services==

[andy_b_1502]

like this: $what_services== "R", "B";

[PFMaBiSmAd]

You want rows where what_services = 'R' or where what_services = 'B'. There's two ways -

 

A)

$query = "SELECT * FROM companies WHERE what_services = 'R' OR  what_services = 'B' ORDER BY approved DESC, company_name ASC";

 

B)

$query = "SELECT * FROM companies WHERE what_services IN('R','B') ORDER BY approved DESC, company_name ASC";

[andy_b_1502]

Thanks,

 

Which one will work best with my while loop do you think?

 

    <?php
$what_services== "R";

    $query = "SELECT * FROM companies WHERE what_services = '$what_services' ORDER BY approved DESC, company_name ASC";
$result = mysql_query($query);

while ( $row = mysql_fetch_array($result)) {
$approved = $row['approved'];
$what_services = $row['what_services'];

[andy_b_1502]

$query = "SELECT * FROM companies WHERE what_services IN('R','B') ORDER BY approved DESC, company_name ASC";

 

worked as expected, many thanks!