[RESOLVED] Select * works but not individual columns

This site is best viewed in a modern browser with JavaScript enabled.

[RESOLVED] Select * works but not individual columns

BlueGhost

Hello,
could you please help me figure out why selecting all works but not individual columns? When selecting individual columns I get an empty result set.
Code is below.

I greatly appreciate the help, i have been looking at this for hours.

function getBookReviews($connection)
{
        //works
        $sql="SELECT * FROM theDatabase Where isbn = " . $_POST['isbn'];

    //returns empty set
//$sql="SELECT index, parent, user, primary, review, spoilers FROM theDatabase Where isbn = " . $_POST['isbn'];

$result = mysql_query($sql, $connection);
$reviews = array();

while ($row = mysql_fetch_array($result))
{
	$review['index'] = $row['index'];
	$review['parent'] = $row['parent'];
	$review['user'] = $row['user'];
	$review['primary'] = $row['primary'];
	$review['review'] = $row['review'];
	$review['spoilers'] = $row['spoilers'];

	array_push($reviews,$review);
}

echo json_encode($reviews);

mysql_free_result($result);
}

NogDog

Try quoting the column names -- in MySQL typically done with the back-tick character -- as some of them may be reserved words.

PS: You can help the debugging by checking to see if the result of your mysql_query() is false, and if so log or output an error with info from mysql_error().

PPS: The PHP MySQL extension is now deprecated, and you should really be using either the MySQLi extension or even the PDO extension.

BlueGhost

That was it, thank you for the help. index and primary are reserved words.

I will do as you advise and look into MySQLi. Thank you again

gk53

when you naming columns try to avoid reserve words like index, primary, user....it will help