Php - How to exclude data from mysql

Question

How to exclude some of countries from List Menu at below? Now my code will list all of country name from database.

Example I want to exclude Albania country from the List Menu. How to implement it according to these code.

Code

    <?php $select_country=mysql_query("SELECT * FROM tbl_country ORDER BY country_name ASC")?>
    <select name="country"  onchange="return get_country(this.value);">
        <option value=""><?=SELECT_COUNTRY?></option>
        <? while($country=mysql_fetch_array($select_country)) {?>
           <option  <? if($_SESSION['getcountry']==$country['id']){ ?> selected="selected"<? }?> value="<?=$country['id']?>">
           <?=$country['country_name']?></option>
        <? } ?>
    </select>

Mysql

id    country_name
1   Afghanistan
2   Aland Islands
3   Albania
4   Algeria
5   American Samoa
6   Andorra

Tell us, what's your problem with Albania?

Philippe Gerber
– Philippe Gerber

2009-08-08 12:01:29 +00:00
Commented Aug 8, 2009 at 12:01 — Philippe Gerber
– Philippe Gerber, Commented Aug 8, 2009 at 12:01
Nothing problem with Albania. Just an example :)

wow
– wow

2009-08-08 12:08:08 +00:00
Commented Aug 8, 2009 at 12:08 — wow
– wow, Commented Aug 8, 2009 at 12:08

Gumbo · Accepted Answer · 2009-08-08 11:47:14Z

7

Either exclude that row from the result set:

SELECT * FROM tbl_country WHERE country_name != "Albania" ORDER BY country_name ASC

Or you skip it with PHP:

<?php
    while($country=mysql_fetch_array($select_country)) {
        if ($country['country_name'] == 'Albania') {
            continue;
        } ?>
    <option <?php if($_SESSION['getcountry']==$country['id']){ ?> selected="selected"<? }?> value="<?=$country['id']?>"><?=$country['country_name']?></option>
<?php } ?>

answered Aug 8, 2009 at 11:47

Gumbo

657k112 gold badges792 silver badges852 bronze badges

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

Comments

astropanic · Accepted Answer · 2009-08-08 11:46:04Z

2

If I have understood your question:

 mysql_query("SELECT * FROM tbl_country WHERE country_name <> 'Algeria' ORDER BY country_name ASC")

answered Aug 8, 2009 at 11:46

astropanic

11k20 gold badges75 silver badges132 bronze badges

1 Comment

Gumbo Over a year ago

He wants to exclude Albania and not Algeria ;)

David Thomas · Accepted Answer · 2009-08-08 11:47:16Z

2

"SELECT * FROM tbl_country WHERE country_name <> "Albania" ORDER BY country_name ASC"

The "<>" is equivalent to "!=" and they both mean 'not equal to', so should in theory select all records from the table where country_name is not equal to the defined "Albania."

I think that the following works, also:

"SELECT * FROM tbl_country WHERE country_name NOT IN("Albania","other_country_name", "another_country_name") ORDER BY country_name ASC"

answered Aug 8, 2009 at 11:47

David Thomas

254k53 gold badges382 silver badges421 bronze badges

Comments

Chris J · Accepted Answer · 2009-08-08 11:48:58Z

1

You could set an array of the countries you wish to exclude...

<?php

$excludeArray = array('Albania','United States') ;

$select_country=mysql_query("SELECT * FROM tbl_country ORDER BY country_name ASC");

echo <<<HTML
    <select name="country"  onchange="return get_country(this.value);">
    <option value=""><?=SELECT_COUNTRY?></option>
HTML;

while($country=mysql_fetch_array($select_country)) {
  if (!in_array($country['country_name'],$excludeArray)) {
    $selected = ($_SESSION['getcountry']==$country['id'] ? 'selected="selected"' : '');
    echo "<option value='" . $country['id'] . "' " . $selected . ">" . $country['country_name'] . "</option>" ;
  }
echo "</select>";


?>

answered Aug 8, 2009 at 11:48

Chris J

7,7942 gold badges27 silver badges26 bronze badges

Comments

Community · Accepted Answer · 2017-12-14 10:12:16Z

1

<?php $select_country=mysql_query("SELECT * FROM tbl_country ORDER BY country_name ASC")?>
    <select name="country"  onchange="return get_country(this.value);">
    <option value=""><?=SELECT_COUNTRY?></option>
    <?php 
       $exclude = array('Afghanistan', 'Andorra');
       while($country=mysql_fetch_array($select_country)) {
         if(!in_array($country['name'], $exclude){
    ?>
    <option  <? if($_SESSION['getcountry']==$country['id']){ ?> selected="selected"<? }?> value="<?=$country['id']?>"><?=$country['country_name']?></option>
    <? }} ?>
    </select>

edited Dec 14, 2017 at 10:12

CommunityBot

11 silver badge

answered Aug 8, 2009 at 11:49

Scharrels

3,06526 silver badges31 bronze badges

Comments

Martijn Pieters · Accepted Answer · 2012-05-26 09:34:20Z

-2

why not just make a status on on your data base? for example albania status show than you can use SELECT FROM country WHERE status='show'

edited May 26, 2012 at 9:34

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

answered May 26, 2012 at 9:29

vicos2

1

Collectives™ on Stack Overflow

Php - How to exclude data from mysql

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related