Mysql Error!!

[stc7outlaw]

I keep getting this error

You have an error in your SQL syntax near '' at line 1

I have looked and looked and looked. I even matched it up to my book and I dont understand what is wrong with the code. Check it:

<?php   


$list =  array( '_COOKIE', '_ENV', '_FILES', '_GET','_POST','_SERVER' ); 
foreach($list as $element) { 
  if( !empty($$element) && is_array($$element) ) { 
        extract($$element); 
    } 
}



$user = "oprods";
$pass = "breakin";
$db  = "pictures";
$table = $_REQUEST['table'];

$conn = mysql_connect('localhost',$user,$pass) or die(mysql_error());
if(!is_resource($conn)) {
   die("Error connecting to mysql.\n");
  }

@mysql_select_db($db,$conn);
$sql = "SELECT description,section FROM $table WHERE id=$id";
$result = @mysql_query($sql,$conn) or die(mysql_error());

while ($newarray = mysql_fetch_array($result)) {
       $description = $newarray['description'];
       $section = $newarray['section'];


}

  /*$res = mysql_query("select * from $table", $conn) // a query that returns an empty set
  $row = mysql_fetch_array($res); // get's 0 since there's no return 
  echo count($row); // echos 1 - since $row is not an array
  echo $row[0]; // echos "", but casts $row as an array? 
  $rows = count($row); // echos 0 now
    */


for ($id = 1; $id <= mysql_num_rows($result); $id++ ) {

 print '<TR>';
 print '<TD width=33%><img src=getdata.php?id='.$id.'&table='.$table.' width=404 height=295></TD>';
 print '<TD width=33%>'.$description.'</TD>';
 print '<TD width=33%>'.$section.'</TD>';
 print '</TR>';
   }


?> 

[TheIceman5]

have you actually confirmed that the value $id exists and not null?

[stc7outlaw]

how would i go about confirming that it exists. Because in the table I know for a fact it exists. Should i put an if statement or something?

[TheIceman5]

echo "The value of ID is ".$id;

[tsinka]

Additionally you might need to use $_GET['id'] instead of $id.

[stc7outlaw]

I echoed id and returned 1
I echoed description and section and they both didnt return anything. It has something to do with the sql commands but I know there is no error in my typing there so what could be wrong.
I took off the or die function and found more errors. Check it:

Warning: Supplied argument is not a valid MySQL result resource in /var/www/html/projects/photos/photos.php on line 46

Warning: Supplied argument is not a valid MySQL result resource in /var/www/html/projects/photos/photos.php on line 61

<?php   


$list =  array( '_COOKIE', '_ENV', '_FILES', '_GET','_POST','_SERVER' );
foreach($list as $element) { 
  if( !empty($$element) && is_array($$element) ) { 
        extract($$element); 
    } 
}



$user = "oprods";
$pass = "breakin";
$db  = "pictures";
$table = $_REQUEST['table'];
$id = $_GET['id'];

$conn = mysql_connect('localhost',$user,$pass) or die(mysql_error());
if(!is_resource($conn)) {
   die("Error connecting to mysql.\n");
  }

@mysql_select_db($db,$conn);
$sql = "SELECT description,section,id FROM $table WHERE id=$id";
$result = mysql_query($sql,$conn); //or die(mysql_error());

while ($newarray = mysql_fetch_array($result)) {
       $description = $newarray['description'];
       $section = $newarray['section'];


}



for ($id = 1; $id <= mysql_num_rows($result); $id++ ) {

 print '<TR>';
 print '<TD width=33%><img src=getdata.php?id='.$id.'&table='.$table.' width=404 height=295></TD>';
 print '<TD width=33%>'.$description.'</TD>';
 print '<TD width=33%>'.$section.'</TD>';
 print '</TR>';

   }
 echo "The value of ID is ".$id;
 echo $description;
 echo $section;
?>

[cgraz]

Try using single quotes around $id

$sql = "SELECT description, section, id FROM $table WHERE id='$id'";

And why is the or die(mysql_error()); part of your code commented out? It's good to have when error checking (even though it probably won't be of much use w/syntax problems).

Cgraz

[kevinsequeira]

$sql = "SELECT description,section,id FROM $table WHERE id=$id";
echo $sql;
$result = mysql_query($sql,$conn); 
if(mysql_error()){
 echo mysql_error();
}

look at what your $sql is, should u give u an idea of why ure getting an error.

if u still have a problem, copy and paste what the $sql is

reg
kevin