[Resolved] [Resolved] Discriminate using MySQL flags

[Jaxeed]

Hi, this should be a fairly easy one to solve I think, but I still cant figure it out. I need to discriminate using a MySQL flag, since it is a field that is an auto_increment, and that field needs to be disabled in my automatic form. It is fairly easy to discriminate on length and type, so that different length strings will generate different size textareas in the form.

Problem is when doing a mysql_field_flags() it is returning all falgs like "not_null primary_key auto_increment ", and then wanting to see if the flag auto_increment is in there, $flagcheck == auto_increment will turn out false anyhow, and $flagcheck != auto_increment will turn out true anyhow.

I've tried to do a $flagcheck == '%auto_increment%' too hoping it would just look if the word auto_increment is in the variable at all, no matter what it says before and after. That didnt work.... so now I cant think of any other ways to find out if a field is auto_increment and thereby assign something different to thatone then the rest.

Please help before I smash my monitor! 🙁 It has to be a way....

[weekender]

split the string using explode

$flags = explode(" ", mysql_field_flags($result, $field_offset));
//$flags is now an array, with an entry for each flag
if(in_array("auto_increment", $flags)){
    echo "the field is auto incremented";
}

hope that helps

adam

[Jaxeed]

THAT DID IT!!! Thanks weekender, you know your stuff! 😃

[weekender]

no worries mate. don't forget to mark the thread resolved, using the link at the bottom of the page

adam