Programming Forums - SQL column as array

i tried that witha few adjustments here and there but it seemd to out put nothing at all. i had array printing in for debugging and even that aint working. plus the code originally outputted a table displaying all rows in the table. Also below is the whole of my code(twice one with you code one with my own that didnt work.) ALso should be output screen shots here:
http://www.1hess.com/piercy/images/

Heres the changes i made:

$results = mysql_query("SELECT `title` FROM c1hess_evo69.nuke_downloads_downloads");

$dbfilearray = new array();

while($row = mysql_fetch_array($results)) {

  array_push($dbfilearray, $row[0]);

  }

Code with your addition:

<?php

$server = 'eupub';

$etmain_cid = '10';

$etpub_cid = '13';

$jaymod_cid = '';

$etpro_cid = '';



$date = date('Y-m-d H-i-s');

$etmain = './etmain';

$etpub = './etpub';

$jaymod = './jaymod';



mysql_connect('localhost','***','*****');





////////////////////////////////////

////////////Etmain/////////////////

//////////////////////////////////









if($directory = opendir($etmain)){



$filearray = scandir($etmain);



print_r($filearray);

echo '<br><br>';



$results = mysql_query("SELECT `title` FROM c1hess_evo69.nuke_downloads_downloads");

$dbfilearray = new array();

while($row = mysql_fetch_array($results)) {

  array_push($dbfilearray, $row[0]);

  }



print_r($dbfilearray);

echo '<br><br>';

$diff = array_diff($filearray, $dbfilearray);

sort($diff);

$size = count($diff);



print_r($diff);

echo '<br><br>';

while ($num <= $size) {

$filedelete = $array[1];

mysql_query("DELETE * FROM c1hess_evo69.nuke_downloads_downloads WHERE `title`='$filedelete'");

array_splice($diff,1,1);

sort($diff);

$num++;

}

?>

My code before your addition:

<?php

$server = 'eupub';

$etmain_cid = '10';

$etpub_cid = '13';

$jaymod_cid = '';

$etpro_cid = '';



$date = date('Y-m-d H-i-s');

$etmain = './etmain';

$etpub = './etpub';

$jaymod = './jaymod';



mysql_connect('localhost','****','****');





////////////////////////////////////

////////////Etmain/////////////////

//////////////////////////////////









if($directory = opendir($etmain)){



$filearray = scandir($etmain);



print_r($filearray);

echo '<br><br>';

$dbrow = mysql_query("SELECT `title` FROM c1hess_evo69.nuke_downloads_downloads");

$dbfilearray = mysql_fetch_array($dbrow);



print_r($dbfilearray);

echo '<br><br>';

$diff = array_diff($filearray, $dbfilearray);

sort($diff);

$size = count($diff);



print_r($diff);

echo '<br><br>';

while ($num <= $size) {

$filedelete = $array[1];

mysql_query("DELETE * FROM c1hess_evo69.nuke_downloads_downloads WHERE `title`='$filedelete'");

array_splice($diff,1,1);

sort($diff);

$num++;

}



echo '<table border="1">Etmain additions:';

while($file = readdir($directory)) {





                if($file != "." && $file != ".." && $file != "index.html"){

                $stat = stat($etmain . '/' . $file);

                $filesize = $stat[7];

                $date = $stat[9];

                echo '<tr><td>' . $file . '</td><td>' . $filesize . '</td></tr>';





mysql_query("INSERT INTO c1hess_evo69.nuke_downloads_downloads (`cid`,`title`,`url`,`description`,`date`,`submitter`,`filesize`,`sub_ip`,`active`) VALUES ('$etmain_cid','$file','http://www.1hess.com/modsandmaps/$server/etmain/$file','Game File for [HESS] $server download to etmain.','$date','Piercy\'s directory bot','$filesize','$ip','1')");





}

}

echo '</table>';



closedir($directory);

}

?>

Ignore some of the excess variables. they bare there for easy change. (as i have to do this for 4 maybe more folders.).

I really appreciate your help,