syntax error, unexpected ';' on line 24

hscorp · #1 (**permalink**) 10-17-09, 16:19

this page has

Quote:

PHP Parse error: syntax error, unexpected ';' on line 24

can anyone check the page

this is line 24

PHP Code:


			
$getTotalHosts = mysql_query("SELECT * FROM mirror WHERE uid = '$file_id'"  or die(mysql_error());

and this is the whole page

PHP Code:


			
<?php



require 'includes/db.inc.php';



function sanitize($input){

    if(is_array($input)){

        foreach($input as $k=>$i){

            $output[$k]=sanitize($i);

        }

    }

    else{

        $output=mysql_real_escape_string($input);

    }   

   

    return $output;

}

$_GET=sanitize($_GET);



$file_id = $_GET['uid'];









$getTotalHosts = mysql_query("SELECT * FROM mirror WHERE uid = '$file_id'"  or die(mysql_error());

$getCompleteHosts = mysql_query("SELECT * FROM mirror WHERE uid = '$file_id'" and status in (2,3) or die(mysql_error());





$getTotalHostCount = mysql_num_rows($getTotalHosts);

$getCompleteHostCount = mysql_num_rows($getCompleteHosts);



$count=0;



if ($getTotalHostCount == $getCompleteHostCount)

{

    $count=1;

    



}



echo $count;





}



?>

mike_bike_kite · #2 (**permalink**) 10-17-09, 17:09

Looks like the bracketing is wrong in that line:

Code:

$getTotalHosts = mysql_query("SELECT * FROM mirror 
         WHERE uid = '$file_id'"  or die(mysql_error());

It should be:

Code:

$getTotalHosts = mysql_query("SELECT * FROM mirror 
          WHERE uid = '$file_id'")  or die(mysql_error());

The following line also looks wrong:

Code:

$getCompleteHosts = mysql_query("SELECT * FROM mirror 
          WHERE uid = '$file_id'" and status in (2,3) or die(mysql_error());

Shouldn't it be:

Code:

$getCompleteHosts = mysql_query("SELECT * FROM mirror 
          WHERE uid = '$file_id' and status in (2,3)") or die(mysql_error());

It also helps if you print out the sql in your die statement.

Mike

hscorp · #3 (**permalink**) 10-17-09, 17:43

thanks it works now

Internet Services

Web Development

Digital Marketing

Consumer Tech