[Resolved] mysql_query $result filter

aleols

Hello,

Im trying to filter out a result row from the code below.
Code is used for getting all domains from the vpopmail database into a selectbox for qmailadmin. Anyhow
the output i get (w/o the html): http://defuse.net/getdom.php

You see the dom_89 on the list? I want the script to ignore
the row when querying.

Hope someone knows how!

Aleksander

<?php
$db = mysql_connect("localhost", "login", "pass");

mysql_select_db("vpopmail",$db);

$result = mysql_query("SELECT * FROM dir_control ORDER BY domain asc ",$db);
while ($myrow = mysql_fetch_row($result)) {

            printf("<option>%s</option>",
            $myrow[0]);
    }

?>

jernhenrik

Err not sure I understand your question completely, but here is a suggestion 🙂

You can use <>

eg:

SELECT * FROM dir_control WHERE domain<>'dom_89' ORDER BY domain ASC

hth

aleols

That moved the 'dom_89' to the top of the list 🙂

I dont want it on the list, remove it from the $result

Thanks!! 🙂

jernhenrik

<>
!=
Not equal:
mysql> SELECT '.01' <> '0.01';
-> 1
mysql> SELECT .01 <> '0.01';
-> 0
mysql> SELECT 'zapp' <> 'zappp';
-> 1

take a look at the documentation:

http://www.mysql.com/doc/en/Comparison_Operators.html

...and remember to out an or die after your query this makes error finding easier:

$result=mysql_query("SELECT * bla bla") or die ("Mysql error: ".mysql_error()."\n");

hth

aleols

$result = mysql_query("SELECT * FROM dir_control WHERE domain!='dom_89' ORDER BY domain asc ",$db);

did the trick 🙂 Thanks!

jernhenrik

great to hear 😃 ...please mark the thread resolved then 😉 you can find the link at the bottom of the page.

don't know if the link works but it's worth a shot🙂
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10249000&is_resolved=1