mysql_fetch_array varning.
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\honung\pages\myfiles.php on line 22
Får det där meddelandet när jag försöker köra denna kod
<?php
//ICONS
$filetypes = array (
'jpg' => 'img.png',
'jpeg' => 'img.png',
'png' => 'img.png',
'gif' => 'img.png',
'ico' => 'img.png',
'pdf' => 'doc.png',
'psd' => 'psd.png',
'txt' => 'txt.png',
'doc' => 'doc.png',
'docx' => 'doc.png',
'7z' => 'rar.png',
'rar' => 'rar.png',
'zip' => 'rar.png',
);
$filesroot = 'http://localhost/choklad/';
$ip = $_SERVER['REMOTE_ADDR'];
$getcount = ("SELECT count(ID) as count FROM files WHERE ip='$ip'");
$result = mysql_query($getcount);
$mcount = mysql_fetch_array($result, 0);
$count = $mcount['count'];
if($count == '0'){
echo'Du har inte laddat upp några filer.';
}
else{
$getfiles = ("SELECT name, displayName,ext,size,timestamp FROM files WHERE ip='$ip' ORDER BY timestamp DESC");
$res = mysql_query($getfiles);
echo '<table class="filetable"><tr><td colspan="2"><u>Filnamn</u></td><td><u>Storlek</u></td><td><u>Datum</u></td></tr>';
while($file = mysql_fetch_array($res)){
$size = $file['size'];
if(strlen($size)>3){
$size = round($size/1048576,2).' MB';
}
else{
$size = $size.' B';
}
echo'<tr>
<td style="width:16px;"><img src="/fileicons/'.$filetypes[$file['ext']].'"/></td>
<td><a href="'.$filesroot.$file['name'].'">'.$file['displayName'].'</a></td>
<td>'.$size.'</td>
<td style="width:105px;">'.date('Y-m-d H:i',strtotime($file['timestamp'])).'</td>
</tr>';
}
echo'</table>';
}
?>
<?php
mysql_close($db);
?>
har suttit och kollat, men hittar inget!