[RESOLVED] Array Problem

[trilithon]

Hi All,

I need to insert the results from the query into an array that will exclude files that are included in the array. Here is the code that I am using:

function home() {

$query = "SELECT * FROM doc WHERE status=0"; 

$result = mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_array($result)){
	$testname[] = $row['full_path'];
foreach ($testname as $value){
$exclude1 = "|"."index.php"."|".$value;

}

echo $exclude1;
}
 $exclude_array = explode("|", $exclude1);

At this stage I am getting the results from the query but the exclude command is only using the last record that was added when doing the explode.

I would appreciate any help with this regard.

Thank you

Max😕

[dagon]

that's a little messed up, i think you want:

<?php
function home(){
	$query = "SELECT * FROM doc WHERE status=0";
	$result = mysql_query($query) or die(mysql_error());
	$exclude_array[] = 'index.php';
	while ( $row = mysql_fetch_array($result) ){
		$exclude_array[] = $row['full_path'];
	}
return $exclude_array;
}

?>

[trilithon]

Thank you,

It worked Perfect.

Regards,

Max