Sql error

[crazybrumi]

there are no errors showing aswell so its a dead end.

    
$sql = "SELECT path  FROM gallery_files WHERE approved = 1 ";

    $items = mysql_query($sql);
    echo mysql_error();
    
    if(mysql_num_rows($items)>0)
    while ($item = mysql_fetch_array($items))
    {
    $main.="<img src=\"../phpThumb/phpThumb.php?src=$item[0]\" width=\"50\" height=\"50\" alt=\"$item[0]\"/>";
    }

this works in main page but as soon as i put it in index it dosnt work even tho there is a database connection valid as im pullin how many poeple have registered etc but for sum reason this dosnt wna work

[xcoderx]

And the error message is?

[subzero]

$sql = "select path from gallery_files where approved = '1' ";$items = mysql_query($sql);echo mysql_error();if(mysql_num_rows($items)>0)while ($item = mysql_fetch_array($items)){$main.="<img src=\"../phpthumb/phpthumb.php?src=$item[0]\" width=\"50\" height=\"50\" alt=\"$item[0]\"/>";}

----
0-0-0-
99999

[crazybrumi]

And the error message is?

thats the point i am not getting no error