mysql_fetch_array() error

[NTLDR]

As I've already said, theres no need to use the while loop and $DB_site->fetch_array as your only getting one row from the DB.

[corsacrazy]

Today at 03:49 PM NTLDR said this in Post #11
As I've already said, theres no need to use the while loop and $DB_site->fetch_array as your only getting one row from the DB.

if i take that out the whole thing just doesnt werk and i get a broken red X instead of the image

atleaset wiv the erro the script is working

[Link14716]

Here's how it should look...

PHP Code:

$newestsql=$DB_site->query_first("SELECT * FROM gal_Object where Freigabe='y' order by newat desc"); 
$getnewthumb=$DB_site->query_first("SELECT * FROM gal_Pictures where Object='$newestsql[ID]' ORDER BY rand(NOW()) DESC");
 // get a random pic
        $tmpnew=explode(".",$getnewthumb['filename']); 
        $newthumbfilename="gt_".$tmpnew['0'].".jpg";
eval( '$newestsql = "' . gettemplate( 'home_newest' ) . '";' ); 


[corsacrazy]

U R A LEGEND took me a few template changes but i finally got it sorted CHEERS TO ALL THE VB people AND ESPECIALLY MR LINK ! im gald i got my self that vb license now