Im using the above function file_exists() for a file on my server with the location http://www.championshipfl.com/xxxxx however this doesnt seem to work as i put in fake locations that are non-existant and it still says they exist.

PHP Code:

                              <?php
                              $count = 0;
                              $sql = mysql_query("SELECT * FROM `****`");
                              while($row = mysql_fetch_array($sql))
                              {
                              //Check To See If Location Exists
                              $filename = "http://www.championshipfl.com/" . $row['location'];
                                if (file_exists($filename) == FALSE) {
                                $count++;
                              $linked = mysql_fetch_array(mysql_query("SELECT * FROM `****` WHERE `id` = '" . $row['linked_to'] . "'"));
                              echo "<tr><td>" . $row['id'] . "</td><td>" . $row['name'] . " (" . $linked['name'] . ")</td><td>http://www.championshipfl.com/" . $row['location'] . "</td></tr>";
                                }
                              }
                              echo $count;
                              if($count == 0)
                              {
                              echo "<tr><td colspan='3'>All Pages Have Existing Locations</td></tr>";
                              } ?>

No worries resolved issue, you have to use the "/home/**/***/****/" method of location!

file_exists takes a relative path NOT an absolute URI.