Updating fields where field = ''

[-Karl-]

This is confusing the hell out of me. I have my code, with a working query:

<?php
include ('config.php');
include ('functions.php');
        
        $sql = mysql_query("SELECT * FROM " . $table ." WHERE `min` = '' ORDER BY `itemid` ASC");
    while ($arr = mysql_fetch_assoc($sql)) {
        massupdateData($arr['name']);
    }
?>

 

If you need to see the massupdateData function just ask. Anyway, when running the query in PHPMyAdmin it works fine and displays the fields where min = '', however, when I run the PHP file. It updates items which I know definitely have some value in the min field. I don't want to post my function here, however, if you can help me I will PM you it

 

Thanks

~Karl

[Mchl]

You know you can usr this WHERE condition in your UPDATE query, right?

 

Anyway, there doesn't seem to be anything wrong with the query, so it must be within the functinon.

[-Karl-]

May I PM you my function?

[Mchl]

No

[ignace]

No

 

Post it so everyone can help you, remove credential details if any.

[-Karl-]

I'll pass.