multiple variables from 1 field

GundamSV7

Hey, I'm trying to get this script to check this one mysql db field to see if it contains one of the numbers I want, so for example, in the field, I input "12345". Now, I want the script to simply see if say, the number "2" is contained within those numbers, any idea how that can be done?

tomhath

Welcome to the world of regular expressions. Kind of an odd concept at first, but well worth the effort to learn:

http://www.phpbuilder.com/manual/function.preg-match.php

GundamSV7

so, the code would be something like:

$getdata = mysql_fetch_array(mysql_query("SELECT * FROM data WHERE data=1"));
// the "i" after the pattern delimiter indicates a case-insensitive search
if (preg_match ("/2/i", "$getdata[data]")) {
    print "A match was found.";
} else {
    print "A match was not found.";
}

where $getdata[data] is my line of numbers, like 12345?