Re: Proper syntax for multiple query string

[Ivan D]

Yea I thought about the query injection thingy, but there's ways to scan and prevent that (like real_escape_string), and the bonus of being able to do 2 or more queries at once can be pricelessly helpfull.
If i'm absolutely sure the parses won't be of malicious nature, can i turn on multi queries somehow?

Heres some more questions
Howcome phpadmin doesnt care about multi queries?
When you lock a table, does the script that locked it only have access?
What if they terminate before unlocking?
What kind of access do other scripts have, just read?
Are there different kinds of locks?
Is there anyway to do a select and some other query (like UPDATE) and still get the results from the select?

Thanks, again