Speed Array or Query?

[trancemission]

I have a table which contains data reagding all the pages on my site, some pages will not have a record. I have a file when placed in a directory will list all the php pages in that Dir. I need to cross reference this with data in my table and produce a report showing which files are in the DB. My files are stored unquily by the $PHP_SELF value.

Sample Page Data:

pageid pagepath comments
1 /security/list.php None
2 /security/admin.php some

Then in the page that lists the file I have a loop set up looping through the php files, my question is in this loop would it be quicker to execute an SQL query to see if there is a record or first select all the pages from the record and place the field pagepath into an Array and then loop through the array each time.

Any others methods are also welcome

Many Thanx
Marcus

[[deleted]]

I'd go for a dynamic SQL statement.
Loop through the files, and build the query as you go..

in pseudo code:

$sQuery = "SELECT * FROM table WHERE 1=0 ";
// start loop
{
$sQuery .= " OR field=\"$filename\"";
};

What wil give you a query like

SELECT * FROM table WHERE 1=0 OR field="this" OR field="that";

In short, it will fetch all records where the filename matches any of the given files.

Now you can loop through the files again, and
for each file, loop through the resultset from the query to find a matching record.