HELP! Error Since php update!, You have an error in your SQL syntax; check the manual that correspond Options

[kysper]

Entering the Site I get an error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id =' at line 1



<?

include ("../inc/***.inc.php");
include ("../inc/*****.inc.php");

$seite = "Direkt";


################################################################################
###

$ip = $_SERVER['REMOTE_ADDR'];

$kriterium = "objekt";
$auswahl = $objekt;

$strsql7 = " SELECT * FROM user_ip";
$strsql7 .= " WHERE ip = '".$ip."' ";
//echo "strsql_select_7: ".$strsql7."<br>";
$handle7 = mysql_query($strsql7,$connect);
$row7 = mysql_fetch_array($handle7);
$seiten_alt = $row7[seiten];
//echo "seite[]: ".$row7[seite]."<br>";
//echo "seiten_alt: ".$seiten_alt."<br>";

$strsql_a = " UPDATE user_ip ";
$strsql_a .= " SET seiten = '".$seiten_alt."<br> ".$land." / ".$objekt."' ";
$strsql_a .= " WHERE ip = '".$ip."' ";

//echo "strsql_a: ".$strsql_a."<br>";
$handle_a = mysql_query($strsql_a,$connect);

if(!(mysql_affected_rows($connect)))
{
$strsql11 = " INSERT INTO user_ip (";
$strsql11 .= " ip, seiten ) ";
$strsql11 .= " VALUES (";
$strsql11 .= " '".$ip."' ";
$strsql11 .= " ,'".$objekt."') ";
//echo "strsql11: ".$strsql11."<br>";
$handle = mysql_query($strsql11,$connect);
}

$datum_meta = date("d-m-Y");
$datum5 = date("Ymd");

$strsql5 = " SELECT * FROM user_count";
$strsql5 .= " WHERE ".$kriterium." = '".$auswahl."' ";
//echo "strsql_select: ".$strsql5."<br>";
$handle5 = mysql_query($strsql5,$connect);
while($row5 = mysql_fetch_array($handle5))

{
$count_h = $row5[count_h];
$count_h5 = $row5[count_h] + 1;
$zeit5 = $row5[zeit];
//echo "zeit[]: ".$row5[zeit]."<br>";
//echo "row5[count_h]: ".$row5[count_h]."<br>";
}

if($datum5 != $zeit5)
{
$strsql3 = " UPDATE user_count";
$strsql3 .= " SET count_h = 0 ";
$strsql3 .= " , zeit = '".$datum5."' ";
$strsql3 .= " WHERE ".$kriterium." = '".$auswahl."' ";
////echo "strsql_h: ".$strsql3."<br>";
$handle = mysql_query($strsql3,$connect) OR die(mysql_error());
}

$strsql_s = " UPDATE ".$land."";
$strsql_s .= " SET count = count + 1 ";
$strsql_s .= " WHERE id = '".$id."' ";

//echo "strsql_s: ".$strsql_s."<br>";
$handle_s = mysql_query($strsql_s,$connect);

$strsql = " UPDATE user_count";
$strsql .= " SET count = count + 1 ";
$strsql .= " WHERE ".$kriterium." = '".$auswahl."' ";

//echo "strsql_update: ".$strsql."<br>";
$handle = mysql_query($strsql,$connect);

if(!(mysql_affected_rows($connect)))
{
$strsql1 = " INSERT INTO user_count (";
$strsql1 .= " objekt, staat, zeit, count ) ";
$strsql1 .= " VALUES (";
$strsql1 .= " '".$objekt."' ";
$strsql1 .= " ,'".$state."' ";
$strsql1 .= " ,'".$datum5."' ";
$strsql1 .= " ,1) ";

//echo "strsql_new: ".$strsql1."<br>";
$handle = mysql_query($strsql1,$connect);
}

$strsql6 = " SELECT * FROM user_count";
$strsql6 .= " WHERE ".$kriterium." = '".$auswahl."' ";
//echo "strsql_select: ".$strsql5."<br>";
$handle6 = mysql_query($strsql6,$connect);
while($row6 = mysql_fetch_array($handle6))

{
$count_h = $row6[count_h];
$count_h6 = $row6[count_h] + 1;
$zeit6 = $row6[zeit];
//echo "zeit[]: ".$row5[zeit]."<br>";
//echo "row5[count_h]: ".$row5[count_h]."<br>";
}

if($datum5 == $zeit6)
{
$count_h = $count_h6 + 1;

$strsql3 = " UPDATE user_count";
$strsql3 .= " SET count_h = '".$count_h6."' ";
$strsql3 .= " WHERE ".$kriterium." = '".$auswahl."' ";
//echo "strsql_h: ".$strsql3."<br>";
//echo "count_h: ".$count_h5."<br>";

$handle = mysql_query($strsql3,$connect) OR die(mysql_error());
}

Can anyone please help me? there is an error since i updated my hosting-contract!

This post has been edited by kysper: Oct 1 2012, 04:41 AM

[Darin McGrew]

Welcome to the wonderful world of debugging.

For starters, I searched for the string "WHERE id" that appeared in the error message. I found this section:

$strsql_s .= " WHERE id = '".$id."' ";

//echo "strsql_s: ".$strsql_s."<br>";
$handle_s = mysql_query($strsql_s,$connect);

Note the echo statement that is commented out? Start by uncommenting it, so you can see what $strsql_s has been set to.