Question

What does ‘mysql_query()’ return on failure?

(a) 0

(b) 1

(c) -1

(d) a non-zero value

The question was posed to me in final exam.

The doubt is from Compound Statement Syntax in chapter SQL Syntax of MySQL

Answer 1

Correct choice is (d) a non-zero value

For explanation: Both of the functions named ‘mysql_query()’ and ‘mysql_real_query()’ return zero for statements that succeed. They return non zero for failure. A statement is successfully executed if the server accepts it.