[EMAIL PROTECTED] wrote:
I agree with you, just see that if .. sql = "SELECT id, '$cat' AS type, ... FROM $cat"; is exactly what is done in prepare statement.
Yes, I acknowledged that in my next message (a reply to yours).
dynamic sql is better than application level statement preparation, when you use stored procedure. but since this is the habit in mysql, i'll keep this for oracle, and other rdbms.
It's not a question of habit. Stored procedures don't exist in mysql until 5.0, which is still in beta and not for production use. We should not assume that people use 5.0 unless they explicitly say they do. If we don't assume 5.0, this point is moot.
P.S. haven't spent days to help. It is easy. And since it was a week-end :o)
Right. That was a reference to the original poster's statement, "i am stuck on this for a few days already."
Mathias
Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]