php mysql

[common]

Hi everyone!

 

I was wondering if anyone could help me??

 

I have a database and one of the column have values like 3, 7, 31, 4, 6 and so on.

Is there a php mysqli function that can call these values in a array?? Because I have a variable that can contain a number between 1 and 31 and I want to check if it matches to a value in the column...

 

thanx

[phpSensei]

You want to do this in one query?

[common]

if there is a way yes...I just don't know of an easy way, just a long way...

 

So i was wondering if there is not an easy way

[phpSensei]

You can use PHP

<?php
/*mysql query*/
$values = "3,7,31,4,6"; 
$array_values = explode(",",$values); // Now the values are in a array

$num = 5 // this is the number you want it to match

if(in_array($num,$array_values)){
print "We have a positive ID.";
}

?>