PHP Query, which value to use to select all

[Andreu]

Hi,

 

I have done the following query:

 

$query = sprintf ("SELECT * FROM users WHERE country LIKE '$selCountry'");

$result = mysql_query($query,$link);

 

I want to obtain the users that are from a certain country but when $selCountry is equal to "All" I want to obtain all of them.

I have tried the query in mysql webpage using '%' and it works but when using this character from the php file it doesn't work.

 

Could someone help me? 

 

Thanks!!!

[Barand]

<?php
if ($selCountry == 'All')
     $query = "SELECT * FROM users";
else
     $query = "SELECT * FROM users WHERE country = '$selCountry'");
?>

[Trium918]

<?php
if ($searchtype == "all_country"){
	$query="SELECT * FROM table_name";
}else{
$query="SELECT * FROM table_name where country='$searchtype'";}
?>

[Andreu]

Hi, thanks for the quick reply 

 

The problem of this "if" is that it works fine if you have to do it just with one but if you have to do it with four, the code gets a bit heavy.

Is there any value to assign to the parameters equivalent to "*".

 

Code:

$query = sprintf ("SELECT * FROM tandem WHERE country LIKE '$selCountry' AND city LIKE '$selCity' AND lang1 LIKE '$iWantToSpeak' AND lang2 LIKE '$iSpeak'");

 

 

CHEERS

[Barand]

LIKE '%' is the SQL wildcard

[Andreu]

Hi,

 

what I don´t understand is why this solution of using % works in the web based query (phpMyAdmin) and it doesn´t when using a php file?

 

What would be your advice to solve the problem without using a series of "if"'s?

 

Thanks

[Barand]

Why do you insist on sprintf() when you are not formatting any variables? To put "%" (which is sprintf escape character) into a sprintf format string you need "%%"

[Andreu]

Thanks!

 

The problem is solved. Very Useful