MySQL not accepting my query string
Posted: Thu Mar 25, 2010 4:00 pm
I can't understand why this is not working, the query string looks line to me, or am I just being blind!
when I echo the query string it looks like this,
I'm getting the error back from the confirm_query function and my php error log is giving me this to think about,
Code: Select all
$query = "SELECT * ";
$query .= "FROM subjects ";
$query .= "WHERE id=" . $subject_id . " ";
$query .= "LIMIT 1";
$result_set = mysql_query($query, $connection);
confirm_query($result_set); Code: Select all
SELECT * FROM subjects WHERE id=1 LIMIT 1mysql_query(): supplied argument is not a valid MySQL-Link resource