getting some errors

[AN-net]

ok trying to code this but its being evil!

PHP Code:

if($view==gal){
$fgall= $DB_site("SELECT gallery_index.gallery_views,gallery.gallery_id,gallery.image_id,gallery.image_url,gallery.image_des,gallery.image_views,gallery.image_rating,gallery.image_date FROM gallery,gallery_index WHERE gallery_index.gallery_views='$id'");
$gallery= $DB_site->fetch_array($fgall)
$views=++$gallery[gallery_index];
$tviews= $views;
$DB_site->query("UPDATE gallery_index SET gallery_views='$tviews' WHERE gallery_id='$id'");
eval('$navbar .= "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('gallery_gal') . '");');
}
?> 


im getting a parse error on Line 21.
Line 21 is this:

PHP Code:

$views=++$gallery[gallery_index]; 


[Xenon]

you forgot a ; one line before

[AN-net]

omg woops, xeon u always catch my small errors.
im so stupid>_<

[AN-net]

ok i cant get this thing to add 1 to # views it gets from DB
this is my code:

PHP Code:

$fgall= $DB_site->query("SELECT gallery_index.gallery_views,gallery.gallery_id,gallery.image_id,gallery.image_url,gallery.image_des,gallery.image_views,gallery.image_rating,gallery.image_date FROM gallery,gallery_index WHERE gallery_index.gallery_views='$id'");
$gallery= $DB_site->fetch_array($fgall);
$views=++$gallery[gallery_index];
$tviews=$views;
$DB_site->query("UPDATE gallery_index SET gallery_views='$tviews' WHERE gallery_id='$id'");
eval('$navbar .= "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('gallery_gal') . '");');
}
?> 


for some reason it just changes em all to 1 and thats it

[AN-net]

anyone have any ideas or tips for making it add one to the views and not just chaning it to one

[assassingod]

1. Don't bump threads until atleast 24 hours later
2. For the UPDATE query, use:

PHP Code:

UPDATE gallery_index SET gallery_views='gallery_views+$tviews' WHERE gallery_id='$id' 


That will add to the views without overwriting the current entry

[AN-net]

dont need to use $gallery[gallery_views]?

[assassingod]

I wouldn't, infact if you only want to add 1 view, i'd use:

PHP Code:

$fgall= $DB_site->query("SELECT gallery_index.gallery_views,gallery.gallery_id,gallery.image_id,gallery.image_url,gallery.image_des,gallery.image_views,gallery.image_rating,gallery.image_date FROM gallery,gallery_index WHERE gallery_index.gallery_views='$id'"); 
$gallery= $DB_site->fetch_array($fgall);  
$DB_site->query("UPDATE gallery_index SET gallery_views='gallery_views+1' WHERE gallery_id='$id'"); 
eval('$navbar .= "' . fetch_template('navbar') . '";'); 
eval('print_output("' . fetch_template('gallery_gal') . '");'); 
} 
?> 


[AN-net]

thanks
ill update the thread as experience more evil problems>_<

[AN-net]

darn still aint adding 1 to the view T_T

heres my current code:

PHP Code:

if($view==gal){
$fgall= $DB_site->query("SELECT gallery_index.gallery_views,gallery.gallery_id,gallery.image_id,gallery.image_name,gallery.image_url,gallery.image_des,gallery.image_views,gallery.image_rating,gallery.image_date FROM gallery,gallery_index WHERE gallery_index.gallery_id='$id' AND gallery.gallery_id='$id'");
while($gallery= $DB_site->fetch_array($fgall))
{
    eval('$gallerybits .= "' . fetch_template('gallery_gal_lvl1') . '";');    
    $DB_site->query("UPDATE gallery_index SET gallery_views='$gallery[gallery_views]+1' WHERE gallery_id='$id'");
}
eval('$navbar .= "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('gallery_gal') . '");');
}