Php did not make mistakes with ordinary sql statements, but it did make mistakes with stored procedures?

  mysql, question


This is the stored procedure getpath

This is the stored procedure reqstudent.

In this way, the call will cause an error in the second query (each of which is possible separately), and the error message: Commands out of sync; You can’t run this command now. Others said that Entre Dos should use mysql_free_result (), but the ezsql I used did not know which parameter mysql_free_result () should pass in.

However, if I don’t use stored procedures, I can execute the query correctly by changing it to a normal sql statement, and there will be no error. I don’t know what the problem is. Is mysql_free_result () or something else wrong?图片描述

Should be inIfRelease in statement$result