[RESOLVED] Check if file exsists

[closer2u2]

For some reason, this query always returns a positive even if the field ppic is empty:

                $sql = "SELECT ppic from table where UID='$userid'";
                $rs = $conn->execute($sql);
                $piccheck = $rs->fields['ppic'];
                $picpath = "./ppic/" . $piccheck;
                $pic = (file_exists($picpath)) ? $picpath : "./ppic/nopic.gif";

All it does is check if the field ppic has an entry, like mypic.jpg, if it is empty, then return nopic.gif

But even when ppic is empty it gives me ./ppic/ in the HTML output....

Sure this must be simple, just can't seem to see it

[bradgrafelman]

That's because if the field is empty, then $piccheck will be an empty string, meaning you're checking if "./ppic/" exists, which it does. You should probably check if $piccheck is empty or not.

[closer2u2]

You are right on the spot, was too much focussing on $picpath

This code worked

 $pic = (!empty($piccheck)) ? $picpath : "./ppic/nopic.gif";

Thanks!