help me please

[azeem123456]

hi i m new learning of php and i making content management system

i having problem in my sql query

problem is this i have make a function which take arguement and find a subject this is my function

}

function get_function_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;

}

}

when i call this function  $selected_subject= get_function_by_id($sel_subj); it gives me error

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

Kindly help me our please please

[shlumph]

You have no space between "subjects" and "where"

 

It's better to print queries like this to prevent mistakes:

$query = "SELECT * FROM subjects WHERE id='{$subject_id}' LIMIT 1";

//or

$query = "SELECT * 
          FROM subjects
          WHERE id='{$subject_id}'
          LIMIT 1";

[azeem123456]

thanks alot sir...... it worked thanks alot

regards