Quick question, on page 640 of Paul Dubois excellent MySQL book the statements on right side of the page for mysql_use_result say:

----You MUST call mysql_fetch_row() to fetch all rows, or "leftover" rows will ---- leak into the result of the next query causing an "out of sync" error.

Question 1: Can't I call mysql_free_result to toss away the left over results? Is there anyway to accomplish this without resorting to fetching all the rows?

----Table can stay read-locked if client pauses in mid-retrieval

Question 2: WOW why would that be and is there anyway around that one. After the query is done should it free the lock. If I am feeding data on a slow network would the table stay locked until the data is sent to the client!?

Thanks Ken