Webwereld

weer error

Gestart doorHenkkoekje14 reacties75 weergaven
Log in om mee te praten

15 berichten · pagina 1 van 1

Henkkoekje

Lid · Topicstarter

Berichten
1.257
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
ik krijg weer errors

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/defined"]defined[/URL][COLOR= #007700]([/COLOR] [COLOR= #DD0000]AVARCADE_[/COLOR] [COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR] [COLOR= #DD0000][/COLOR] [COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$cat_numb[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_result"]mysql_result[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT COUNT(*) as Num FROM ava_games WHERE featured=1 AND published=1"[/COLOR][COLOR= #007700]),[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]);[/COLOR]

[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_numb[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR]
    [COLOR= #0000BB]$category_games[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM ava_games WHERE featured=1 AND published=1 ORDER BY id desc"[/COLOR][COLOR= #007700]);[/COLOR]
    
    [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$category_games[/COLOR][COLOR= #007700])) {[/COLOR]
    
        [COLOR= #0000BB]$featured_game[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]plays[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hits[/COLOR][COLOR= #007700]]);[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/strlen"]strlen[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]]) >[/COLOR] [COLOR= #0000BB]$template[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]home_game_chars[/COLOR][COLOR= #007700]]) {[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]] =[/COLOR] [URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$template[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]home_game_chars[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"..."[/COLOR][COLOR= #007700];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]]; 
        }[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/strlen"]strlen[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]description[/COLOR][COLOR= #007700]]) >[/COLOR] [COLOR= #0000BB]$template[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]home_game_desc_chars[/COLOR][COLOR= #007700]]) {[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]description[/COLOR][COLOR= #007700]] =[/COLOR] [URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]description[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$template[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]home_game_desc_chars[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"..."[/COLOR][COLOR= #007700];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]description[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]description[/COLOR][COLOR= #007700]]; 
        }[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_on[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]url[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/index.php?task=view&amp;id=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_on[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700]) {[/COLOR]
            [COLOR= #0000BB]$cat_name[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT name FROM ava_cats WHERE id=$cat_games[category_id]"[/COLOR][COLOR= #007700]));[/COLOR]
            [COLOR= #0000BB]$seo_name[/COLOR] [COLOR= #007700]=[/COLOR] seoname[COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]]);[/COLOR]
            [COLOR= #0000BB]$seo_cat_name[/COLOR] [COLOR= #007700]=[/COLOR] seoname[COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_name[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]]);[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]url[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$seo_cat_name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$seo_name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_extension[/COLOR][COLOR= #007700]];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$seo_name[/COLOR] [COLOR= #007700]=[/COLOR] seoname[COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]]);[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]url[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/view/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$seo_name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_extension[/COLOR][COLOR= #007700]];
        }[/COLOR]
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]import[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]image_url[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/games/images/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000].png[/COLOR][COLOR= #007700];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]import[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]3[/COLOR][COLOR= #007700]) {[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]image_url[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/games/images/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]image[/COLOR][COLOR= #007700]];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]image_url[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]image[/COLOR][COLOR= #007700]];
        }[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$user[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]admin[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) 
        {[/COLOR] 
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]admin_edit[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #DD0000]<a href="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/admin/?task=manage_games&amp;id=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">Edit</a>[/COLOR][COLOR= #007700];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] 
        [COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]admin_edit[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700];
        }[/COLOR]    
        
        [COLOR= #FF8000]// Define the overall rating for use in the template[/COLOR]
        [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]rating[/COLOR][COLOR= #007700]] =[/COLOR] GenerateRating[COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]rating[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #DD0000]featured[/COLOR][COLOR= #007700]);[/COLOR]
        
        [URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000].[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]template_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$template[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]featured_game[/COLOR][COLOR= #007700]]);
    }
}[/COLOR]
?>


error

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/voorbeeld/domains/gamekasteel.nl/public_html/includes/homepage/featured_games.inc.php on line 3


//edit: en als ik categorien maak krijg ik dit

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/voorbeeld/domains/gamekasteel.nl/public_html/includes/modules/categories_menu.php on line 20
()


script

[COLOR= #0000BB]<?php
$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM ava_cats ORDER BY name"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$total_cats[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_result"]mysql_result[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT COUNT(*) as Num FROM ava_cats"[/COLOR][COLOR= #007700]),[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$total_cats2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
    
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700])) {[/COLOR]
    
    [COLOR= #0000BB]$total_cats2[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$total_cats2[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$seo_name[/COLOR] [COLOR= #007700]=[/COLOR] seoname[COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]]);[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_on[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<a href="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/index.php?task=category&id=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</a>[/COLOR][COLOR= #007700];
    }[/COLOR]
    [URL="http://www.php.net/else"]else[/URL] [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_on[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700]) {[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<a href="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/cat/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$seo_name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]/newest-1[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_extension[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</a>[/COLOR][COLOR= #007700];
    }[/COLOR]
    [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<a href="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/cat/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$seo_name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_extension[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</a>[/COLOR][COLOR= #007700];
    }[/COLOR]
    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cat_numbers[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
        [COLOR= #0000BB]$cat_numb[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_result"]mysql_result[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT COUNT(*) as Num FROM ava_games WHERE category_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]),[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<em>([/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cat_numb[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000])</em>[/COLOR][COLOR= #007700];
    }[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$total_cats2[/COLOR] [COLOR= #007700]!=[/COLOR] [COLOR= #0000BB]$total_cats[/COLOR][COLOR= #007700]) {[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$template[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]categories_menu_seperator[/COLOR][COLOR= #007700]];
    }
}[/COLOR]
?>


//edit: 2 berichten samengevoegd
0
Henkkoekje

Lid · Topicstarter

Berichten
1.257
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
als ik categorien maak krijg ik dit

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/voorbeeld/domains/gamekasteel.nl/public_html/includes/modules/categories_menu.php on line 20
()


script

[COLOR= #0000BB]<?php
$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM ava_cats ORDER BY name"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$total_cats[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_result"]mysql_result[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT COUNT(*) as Num FROM ava_cats"[/COLOR][COLOR= #007700]),[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$total_cats2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
    
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700])) {[/COLOR]
    
    [COLOR= #0000BB]$total_cats2[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$total_cats2[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$seo_name[/COLOR] [COLOR= #007700]=[/COLOR] seoname[COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]]);[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_on[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<a href="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/index.php?task=category&id=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</a>[/COLOR][COLOR= #007700];
    }[/COLOR]
    [URL="http://www.php.net/else"]else[/URL] [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_on[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700]) {[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<a href="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/cat/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$seo_name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]/newest-1[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_extension[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</a>[/COLOR][COLOR= #007700];
    }[/COLOR]
    [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<a href="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/cat/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$seo_name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_extension[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</a>[/COLOR][COLOR= #007700];
    }[/COLOR]
    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]cat_numbers[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
        [COLOR= #0000BB]$cat_numb[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_result"]mysql_result[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT COUNT(*) as Num FROM ava_games WHERE category_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]),[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<em>([/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cat_numb[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000])</em>[/COLOR][COLOR= #007700];
    }[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$total_cats2[/COLOR] [COLOR= #007700]!=[/COLOR] [COLOR= #0000BB]$total_cats[/COLOR][COLOR= #007700]) {[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$template[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]categories_menu_seperator[/COLOR][COLOR= #007700]];
    }
}[/COLOR]
?>
0
Kenzo

Lid

Berichten
1.314
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Je hebt 2 mysql querys achter elkaar gescript en dan kan op deze manier volgens mij niet.
Wat wil je precies met die query bereiken?
0
Henkkoekje

Lid · Topicstarter

Berichten
1.257
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
dit zijn zodat ik categorien ziet kijk www.gamekasteel.nl maar
0
Alemaalte

Lid

Berichten
5.957
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Staan er wel games in?
0
Henkkoekje

Lid · Topicstarter

Berichten
1.257
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
ja die pakket die ik erop zet import ik via mysql dat moet daarna komt die error
0
Kenzo

Lid

Berichten
1.314
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Probeer dit is:

$cat_numb1 = mysql_query("SELECT COUNT(*) as Num FROM ava_games WHERE featured=1 AND published=1");
$cat_numb = mysql_result($cat_numb1,0);


Als ik denk wat jij bedoeld?
0
Alemaalte

Lid

Berichten
5.957
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Volgens mij is die as Num fout.
0
Henkkoekje

Lid · Topicstarter

Berichten
1.257
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
categorieën werken inmiddels nu heb ik nog 2 fouten

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/defined"]defined[/URL][COLOR= #007700]([/COLOR] [COLOR= #DD0000]AVARCADE_[/COLOR] [COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR] [COLOR= #DD0000][/COLOR] [COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$cat_numb[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_result"]mysql_result[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT COUNT(*) as Num FROM ava_games WHERE featured=1 AND published=1"[/COLOR][COLOR= #007700]));[/COLOR]

[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_numb[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR]
    [COLOR= #0000BB]$category_games[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM ava_games WHERE featured=1 AND published=1 ORDER BY id desc"[/COLOR][COLOR= #007700]);[/COLOR]
    
    [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$category_games[/COLOR][COLOR= #007700])) {[/COLOR]
    
        [COLOR= #0000BB]$featured_game[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]plays[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hits[/COLOR][COLOR= #007700]]);[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/strlen"]strlen[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]]) >[/COLOR] [COLOR= #0000BB]$template[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]home_game_chars[/COLOR][COLOR= #007700]]) {[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]] =[/COLOR] [URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$template[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]home_game_chars[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"..."[/COLOR][COLOR= #007700];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]]; 
        }[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/strlen"]strlen[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]description[/COLOR][COLOR= #007700]]) >[/COLOR] [COLOR= #0000BB]$template[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]home_game_desc_chars[/COLOR][COLOR= #007700]]) {[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]description[/COLOR][COLOR= #007700]] =[/COLOR] [URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]description[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$template[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]home_game_desc_chars[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"..."[/COLOR][COLOR= #007700];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]description[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]description[/COLOR][COLOR= #007700]]; 
        }[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_on[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]url[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/index.php?task=view&amp;id=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_on[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700]) {[/COLOR]
            [COLOR= #0000BB]$cat_name[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT name FROM ava_cats WHERE id=$cat_games[category_id]"[/COLOR][COLOR= #007700]));[/COLOR]
            [COLOR= #0000BB]$seo_name[/COLOR] [COLOR= #007700]=[/COLOR] seoname[COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]]);[/COLOR]
            [COLOR= #0000BB]$seo_cat_name[/COLOR] [COLOR= #007700]=[/COLOR] seoname[COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_name[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]]);[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]url[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$seo_cat_name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$seo_name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_extension[/COLOR][COLOR= #007700]];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$seo_name[/COLOR] [COLOR= #007700]=[/COLOR] seoname[COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]]);[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]url[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/view/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$seo_name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_extension[/COLOR][COLOR= #007700]];
        }[/COLOR]
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]import[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]image_url[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/games/images/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000].png[/COLOR][COLOR= #007700];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]import[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]3[/COLOR][COLOR= #007700]) {[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]image_url[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/games/images/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]image[/COLOR][COLOR= #007700]];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]image_url[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]image[/COLOR][COLOR= #007700]];
        }[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$user[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]admin[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) 
        {[/COLOR] 
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]admin_edit[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #DD0000]<a href="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/admin/?task=manage_games&amp;id=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">Edit</a>[/COLOR][COLOR= #007700];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] 
        [COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]admin_edit[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700];
        }[/COLOR]    
        
        [COLOR= #FF8000]// Define the overall rating for use in the template[/COLOR]
        [COLOR= #0000BB]$featured_game[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]rating[/COLOR][COLOR= #007700]] =[/COLOR] GenerateRating[COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_games[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]rating[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #DD0000]featured[/COLOR][COLOR= #007700]);[/COLOR]
        
        [URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000].[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]template_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$template[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]featured_game[/COLOR][COLOR= #007700]]);
    }
}[/COLOR]
?>


fout

Warning: Wrong parameter count for mysql_result() in /home/voorbeeld/domains/gamekasteel.nl/public_html/includes/homepage/featured_games.inc.php on line 3


code 2

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/defined"]defined[/URL][COLOR= #007700]([/COLOR] [COLOR= #DD0000]AVARCADE_[/COLOR] [COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR] [COLOR= #DD0000][/COLOR] [COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$therow[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM ava_cats ORDER BY name"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700])) {[/COLOR]
    [COLOR= #0000BB]$cat_numb[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_result"]mysql_result[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT COUNT(*) as Num FROM ava_games WHERE category_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND published=1"[/COLOR][COLOR= #007700]),[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$cat_numb[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR]
         [COLOR= #0000BB]$therow[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$therow[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
     
         [COLOR= #0000BB]$category[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]name[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]]);[/COLOR]
         [COLOR= #0000BB]$seo_name[/COLOR] [COLOR= #007700]=[/COLOR] seoname[COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]]);[/COLOR]
    
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_on[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR]
            [COLOR= #0000BB]$category[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]url[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #DD0000]index.php?task=category&amp;id=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_on[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700]) {[/COLOR]
            [COLOR= #0000BB]$category[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]url[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/cat/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$seo_name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]/newest-1[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_extension[/COLOR][COLOR= #007700]];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$category[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]url[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/cat/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$seo_name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]/p1[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]seo_extension[/COLOR][COLOR= #007700]];
        }[/COLOR]
    
    
        [URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000].[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$setting[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]template_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]/[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$template[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]home_cat[/COLOR][COLOR= #007700]]);[/COLOR]
    
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$therow[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]$template[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]homepage_columns[/COLOR][COLOR= #007700]]) {[/COLOR]
            [COLOR= #0000BB]$therow[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];
        }
    }
}[/COLOR]
?>


fout

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/voorbeeld/domains/gamekasteel.nl/public_html/includes/homepage/categories.inc.php on line 6

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/voorbeeld/domains/gamekasteel.nl/public_html/includes/homepage/categories.inc.php on line 6

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/voorbeeld/domains/gamekasteel.nl/public_html/includes/homepage/categories.inc.php on line 6

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/voorbeeld/domains/gamekasteel.nl/public_html/includes/homepage/categories.inc.php on line 6

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/voorbeeld/domains/gamekasteel.nl/public_html/includes/homepage/categories.inc.php on line 6

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/voorbeeld/domains/gamekasteel.nl/public_html/includes/homepage/categories.inc.php on line 6

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/voorbeeld/domains/gamekasteel.nl/public_html/includes/homepage/categories.inc.php on line 6

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/voorbeeld/domains/gamekasteel.nl/public_html/includes/homepage/categories.inc.php on line 6

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/voorbeeld/domains/gamekasteel.nl/public_html/includes/homepage/categories.inc.php on line 6

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/voorbeeld/domains/gamekasteel.nl/public_html/includes/homepage/categories.inc.php on line 6

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/voorbeeld/domains/gamekasteel.nl/public_html/includes/homepage/categories.inc.php on line 6
0
Kenzo

Lid

Berichten
1.314
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
zet mijn script eens in bijde.

Of:
$cat_numb = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM ava_games WHERE category_id=".$row[id]." AND published=1"));

Voor script 2
0
Henkkoekje

Lid · Topicstarter

Berichten
1.257
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Warning: Wrong parameter count for mysql_result() in /home/voorbeeld/domains/gamekasteel.nl/public_html/includes/homepage/categories.inc.php on line 4
0
Kenzo

Lid

Berichten
1.314
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Ja en dan mijn script erin behalve dat ,0 dat moet je weghalen.
0
Henkkoekje

Lid · Topicstarter

Berichten
1.257
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
ik snap hem niet ,0 staat er niet in
0
Simon

Lid

Berichten
262
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
bouw eerst eens een fatsoenlijk fout melding in.
en als je bij de gegevens in database een rij gelijk is gebruik dan een query met een join.
werkt simpeler en sneller dan heel veel query in bouwen.

ow ja haal * uit je select query!
zo vertraag je script!
0
Henkkoekje

Lid · Topicstarter

Berichten
1.257
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
het is toch nulled versie dnek dat het daarom komt ik ga binnenkort de orginele versie kopen
0

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.

Editor laden…

Praat mee met de One2xs-community.

Inloggen om te reageren