Request returned invalid content type

lakupekka

I'm new to PHP, hopefully someone can help me!

my program is trying to access MySQL database and get the value of one particular field: Id and pass it onto Insert query.
The code is:

$queryId = "SELECT Id FROM category WHERE category.description = 'XXX' ");
$result = mysql_query($queryId);
$catId = mysql_result($result);

$query = "INSERT INTO message (phoneNo, message, time, Id)
values ('$phone', '$message','$time', '$catId')";

Without the ID bit, the insert query works fine. However after I added the line with :

mysql_result($result)

it looks like it causes this error:

Command not completed. Request returned an invalid content type: text/html: charset=ISO-8859-1.

My database has: type InnoDB and collation latin1_general_cs.
The PHP doc has: header("Content-Type: text/plain");
changing that to html did not help!

I simply don't have a clue what's wrong.
Thanks for your help!

cahva

You need to set the int row in mysql_result:

$catId = mysql_result($result,0);

lakupekka

Moi Cahva and thanks, but I had already tried it and it didn't work.
Do you think this could be an installation or some setting causing the problem?

Kudose

Does:

$queryId = mysql_query("SELECT Id FROM category WHERE description='XXX'");
$result = mysql_fetch_array($queryId);
$catId = $result['Id'];

produce the same error?

lakupekka

That worked. Thanks a million.
But I would love to know what caused it in the first place?
Any idea?

Lakupekka

Kudose

I dunno, really the only difference is that I used mysql_fetch_array over mysql_result.

They both have about the same preformance. So little difference that you shouldnt notice.

Also, I changed your SQL, changing category.description to just description.

There isnt a need to specify the table name before the column name if your only quering one table.