select not null values from table Mysql

Question

guys i have problems with select not null values from my table

$tabelka = mysql_fetch_array(mysql_query("select * from ".$server_db.".paczka_przedmiot where cos = ".$losuj['test1']." 
or cos = ".$losuj['test2']."
or cos = ".$losuj['test3']."
or cos = ".$losuj['test4']."
or cos = ".$losuj['test5']."
or cos = ".$losuj['test6']." order by rand() limit 1"));
$szansa = rand(1,100000);

i arleady try with add and (cos IS NOT NULL) but doesnt work here is my full code

$tabelka = mysql_fetch_array(mysql_query("select * from ".$server_db.".paczka_przedmiot where cos = ".$losuj['test1']." 
or cos = ".$losuj['test2']."
or cos = ".$losuj['test3']."
or cos = ".$losuj['test4']."
or cos = ".$losuj['test5']."
or cos = ".$losuj['test6']."  and (cos IS NOT NULL) order by rand() limit 1"));
$szansa = rand(1,100000);

@rowmoin Nothing but still select from tables field with a null value — Dawid Wiewiór
– Dawid Wiewiór, Commented Jul 23, 2017 at 15:58
Both of your queries should not return anay row where cos is NULL. BTW: You can use WHERE cos IN(.., .., ..) instead of multiple OR conditions. — Paul Spiegel
– Paul Spiegel, Commented Jul 23, 2017 at 16:24

rowmoin · Accepted Answer · 2017-07-23 17:40:06Z

1

You can use alternative query but its not a standard:

SELECT *
FROM table 
WHERE NOT (YourColumn <=> NULL);

You also should use uppercase "AND"

You can try this also:

mysql_fetch_array(mysql_query("select * from ".$server_db.".paczka_przedmiot where cos IS NOT NULL AND (cos = ".$losuj['test1']. " 
OR cos = ".$losuj['test2']. "
OR cos = ".$losuj['test3']. "
OR cos = ".$losuj['test4']. "
OR cos = ".$losuj['test5']. "
OR cos = ".$losuj['test6']. ") ORDER BY rand() LIMIT 1"));

edited Jul 23, 2017 at 17:40

answered Jul 23, 2017 at 16:07

rowmoin

7092 gold badges8 silver badges17 bronze badges

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

19 Comments

Dawid Wiewiór Over a year ago

don't return any values

rowmoin Over a year ago

Both of your queries should not return anay row where cos is NULL. Are you sure do you have a value for this query?

Dawid Wiewiór Over a year ago

$losuj['test2'] = 2 $losuj['test1'] = 1 $losuj['test3'] = 3 $losuj['test4'] = 4 $losuj['test5'] = null $losuj['test6'] null

rowmoin Over a year ago

what do you want to mean by this? do you have a value in your table where cos=2 or cos=1?

rowmoin Over a year ago

Could you please try again mysql_fetch_array(mysql_query("select * from ".$server_db.".paczka_przedmiot where cos IS NOT NULL AND (cos = ".$losuj['test1']. " OR cos = ".$losuj['test2']. " OR cos = ".$losuj['test3']. " OR cos = ".$losuj['test4']. " OR cos = ".$losuj['test5']. " OR cos = ".$losuj['test6']. ") ORDER BY rainnd() LIMIT 1")); I have some changed in query

|

Raul Luna · Accepted Answer · 2017-07-23 22:10:52Z

I am afraid that the problem is in the parenthesis. This correction should work (pay attention to the parenthesis):

$tabelka = mysql_fetch_array(mysql_query("select * from ".$server_db.".paczka_przedmiot where (cos = ".$losuj['test1']." 
or cos = ".$losuj['test2']."
or cos = ".$losuj['test3']."
or cos = ".$losuj['test4']."
or cos = ".$losuj['test5']."
or cos = ".$losuj['test6']." ) and (cos IS NOT NULL) order by rand() limit 1"));
$szansa = rand(1,100000);

Collectives™ on Stack Overflow

select not null values from table Mysql

2 Answers 2

19 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

19 Comments

Comments

Related