Fout in query

Heey,

Ben al tig uur bezig met een script, en loop nu tegen klein probleempje,

[COLOR= #0000BB]<?php $query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]INSERT INTO visitors 
                        (
                            id, ip, host_name, times_visited
                         )VALUES (
                            [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$id[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000],[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$ip[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000],[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$host[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000],[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$value[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]
                        )
                    [/COLOR][COLOR= #007700]);[/COLOR]
?>

Er word niks in DB gezet, Waarschijnlijk is het een slordigheidsfoutje maarja,

mysql_query nergens gebruikt?

Weinig slaap veel coden, werkt nog steeds niet.

$query =
Weghalen

Foutafhandeling staat nergens?

Ik denk dat je ergens een afsluiting } vergeten bent

gaan we nou allemaal gokken wat het probleem kan zijn? Doe eerst die foutafhandeling er maar bij

Foutafhandeling staat er onder, Liet alleen de query zien.

Nou wat is de error?

Leachers gonna leach:

Hier het hele script heb half jaar niet coded... Valt me toch weer vies tegen

[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #FF8000]/**
 * @author Wouter Polman
 * @copyright 2012
 * @project Increasing safety
*/[/COLOR]
[URL="http://www.php.net/require_once"]require_once[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]../include/db_connect.php[/COLOR][COLOR= #007700]);[/COLOR]

[COLOR= #0000BB]$id[/COLOR]    [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_insert_id"]mysql_insert_id[/URL][COLOR= #007700]();[/COLOR]
[COLOR= #0000BB]$ip[/COLOR]   [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REMOTE_ADDR[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$host[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/gethostbyaddr"]gethostbyaddr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$ip[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$select[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]
                    SELECT times_visited
                    FROM [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$db_name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000] 
                    WHERE ip=[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$ip[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]
         [/COLOR][COLOR= #007700]);[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$select[/COLOR][COLOR= #007700])){[/COLOR]
    [COLOR= #0000BB]$value[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
    [COLOR= #0000BB]$value[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$select[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700];
}[/COLOR]


[COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]INSERT INTO visitors 
                        (
                            id, ip, host_name, times_visited
                         )VALUES (
                            [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$id[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000],[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$ip[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000],[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$host[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000],[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$value[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]
                        )
                    [/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700])){[/COLOR]
    [COLOR= #0000BB]$vistors_update[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]succes[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
    [COLOR= #0000BB]$visitors_update[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]fail[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<b>Could not update visitors database</b><br />[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]().[/COLOR][URL="http://www.php.net/die"]die[/URL][COLOR= #007700]();
}[/COLOR]
?>

Wat is de error............?

Oke, dat de helft van de bestand niet gescript was

Wattefak?

Kan je ook concreet even antwoorden op onze vragen?
En voeg nou eens die foutafhandeling toe, door met if-else te kijken wat mysql_query terug geeft, Als dit false is, toon je mysql_error()

Als je een query doet doe je dit met "" en niet met . Ook geef je geen ID mee bij het inserten, hiervoor gebruik je A.i

[COLOR= #0000BB]<?php $query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO visitors 
                        (
                            id, ip, host_name, times_visited
                         )VALUES (
                            "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$id[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]","[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$ip[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]","[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$host[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]","[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$value[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"
                        )
                    "[/COLOR][COLOR= #007700]);[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]){[/COLOR]
        [COLOR= #FF8000]// toegevoegd[/COLOR]
[COLOR= #007700]}[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]();
}[/COLOR]

?>

Ofzo