[SOLVED] sql read error

[blueman378]

hi guys, this code should be self explanatory,:

<?php
$fil = $_POST["name"]
    $q = "SELECT * FROM " . Games . "
          WHERE gName = '$fil'
          ORDER BY `gName` ASC
         ";   
    $result = $database->query($q) or die("Error: " . mysql_error());
    /* Error occurred, return given name by default */
    $num_rows = mysql_numrows($result);
    if( $num_rows == 0 ){
      return 'Game Not Found!';
    }

    while( $row = mysql_fetch_assoc($result) ) {
     echo $row[gSwfFile];
    }

?>

 

but i get :

Parse error: syntax error, unexpected T_VARIABLE in C:\wamp\www\admin\file.php on line 3

 

any ideas?

 

thanks people

[rajivgonsalves]

you missed a simicolin

 

$fil = $_POST["name"]

 

should be

 

$fil = $_POST["name"];

[PC Nerd]

q = "SELECT * FROM " . Games . "

          WHERE gName = '$fil'

          ORDER BY `gName` ASC

        ";

 

 

just place it in one line like this ( you also missed a $ i think)

 

$q = "SELECT * FROM ".$Games." WHERE gName = '".$fill."' ORDER BY gName ASC";

 

Hope that helps

[blueman378]

q = "SELECT * FROM " . Games . "

          WHERE gName = '$fil'

          ORDER BY `gName` ASC

        ";

 

 

just place it in one line like this ( you also missed a $ i think)

 

$q = "SELECT * FROM ".$Games." WHERE gName = '".$fill."' ORDER BY gName ASC";

 

Hope that helps

 

the reason it is split up is error checking eg the enters dont create any problems but it means when it says error on line XX it is easier to tell thanks,

 

but it got rid of that error ( the semicolon i mean)

 

thanks guys

[blueman378]

but now i get :

Warning: rename(../games_ins/1,../games_uins/1) [function.rename]: No such file or directory in C:\wamp\www\admin\gameuninstaller.php on line 160

 

which is :

rename("../games_ins/$file", "../games_uins/$file");

 

$file is a include which includes:

<?php
$fil = $_POST["name"];
    $q = "SELECT * FROM " . Games . "
          WHERE gName = '$fil'
          ORDER BY `gName` ASC
         ";   
    $result = $database->query($q) or die("Error: " . mysql_error());
    /* Error occurred, return given name by default */
    $num_rows = mysql_numrows($result);
    if( $num_rows == 0 ){
      return 'Game Not Found!';
    }

    while( $row = mysql_fetch_assoc($result) ) {
     echo $row[gSwfFile];
    }

?>

[blueman378]

btw the expected output should be 1.swf

 

thanks

[rajivgonsalves]

check your db maybe you have not stored the filename correctly if all your files are going to be swf then you can just modify the code to read

 

rename("../games_ins/{$file}.swf", "../games_uins/{$file}.swf");