Hi,
I am wanting to write a nesting of queries without having to retrieve all the records of the first query (because of the volume).
<pseudo code, using MySQL 5. alpha/PHP mysqli C connector>
res1 = query(db, sql1, USE_DATA);
while (row1 = fetch_row(res1))
{ res2 = query(db, sql2_function_of(row1);
row2 = fetch_row(res2, USE_DATA);
free_result(res2); }
free_result(res1);From my reading this seem to violate two principal I have used elsewhere
1) query 1 is still busy, so I can't begin a query 2 -- can I open a new connection to get around this?
2) I didn't read all the results of query 2, so they may show up somewhere I don't want them?
Is there a way to do this, does it work and I am missing something?
Thanks,
Don.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
