Newbie Syntax help

[brian914]

I have the following and it gives me an error.

 

function get_subject_by_id($subject_id) {

global $connection;

$query = "SELECT * ";

$query .= "FROM subjects ";

$query .= "WHERE id=" . $subject_id ." ";

$query .= "LIMIT 1";

$result_set = mysql_query($query, $connection);

confirm_query($result_set);

if($subject = mysql_fetch_array($result_set)) {

return $subject;

} else {

return NULL;

}

}

 

 

If I comment out the following line, it no longer gives me the error. But it also does not do what it needs to 

$query .= "WHERE id=" . $subject_id ." ";

 

 

I am getting this from a tutorial, so it seems like I have everything. What am I missing?

 

Thanks a lot for any help!

 

 

 

[papaface]

use

 function get_subject_by_id($subject_id) {
   global $connection;
   $query = "SELECT * ";
   $query .= "FROM subjects ";
   $query .= "WHERE id=" . $subject_id;
   $query .= " LIMIT 1";
   $result_set = mysql_query($query, $connection);
   confirm_query($result_set);
   if($subject = mysql_fetch_array($result_set)) {
      return $subject;   
   } else {
      return NULL;
   }
}

[xstevey_bx]

try

 

global $connection;
  $query = "SELECT * FROM subjects WHERE id='$subject_id' LIMIT 1";
  $result_set = mysql_query($query, $connection);
  confirm_query($result_set);
  if($subject = mysql_fetch_array($result_set)) {
     return $subject;   
  } else {
     return NULL;
  }
}

[kenrbnsn]

You didn't indicate the error you got, so there is no way we can tell you exactly what is wrong. We can only guess.

 

Ken

[papaface]

The error was he had an extra "

Edit:

Ok maybe he didnt, just my eyes hurting lol. Ignore my code.

[brian914]

I tried the above and it did not work.

 

The error I get is:

 

Database query failed: 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 'LIMIT 1' at line 1