mysql_query doesn't allow but one query at a time. You're not going to be able to define any but the most trivial stored procedures with it, given that limitation.
You generally shouldn't be using the mysql extension anyway -- it's ancient, and was made for versions of MySQL that didn't even have such things as stored procedures. Why it still exists is beyond me.
Anyway, you could use the mysqli extension; there's even an example in the docs an example in the docs. It can be used quite similarly to the old procedural way, if you're more comfortable with that.
mysql_query doesn't allow but one query at a time. You're not going to be able to define any but the most trivial stored procedures with it, given that limitation.
You generally shouldn't be using the mysql extension anyway -- it's ancient, and was made for versions of MySQL that didn't even have such things as stored procedures. Why it still exists is beyond me.
Anyway, you could use the mysqli extension; there's even an example in the docs. It can be used quite similarly to the old procedural way, if you're more comfortable with that.
mysql_query doesn't allow but one query at a time. You're not going to be able to define any but the most trivial stored procedures with it, given that limitation.
You generally shouldn't be using the mysql extension anyway -- it's ancient, and was made for versions of MySQL that didn't even have such things as stored procedures. Why it still exists is beyond me.
Anyway, you could use the mysqli extension; there's even an example in the docs. It can be used quite similarly to the old procedural way, if you're more comfortable with that.
mysql_query doesn't allow but one query at a time. You're not going to be able to define any but the most trivial stored procedures with it, given that limitation.
You generally shouldn't be using the mysql extension anyway -- it's ancient, and was made for versions of MySQL that didn't even have such things as stored procedures. Why it still exists is beyond me.
Anyway, you could use the mysqli extension; there's even an example in the docs. It can be used quite similarly to the old procedural way, if you're more comfortable with that.