Re: Looking up a value in a 'subtable' and inserting it if it doesn't exist

[Dave Kennard]

I'm using mysqli->multi_query(), so I thought that all the queries would be sent to mysql in one go. But now I think about it, I guess it must do round trips to mysql for each query otherwise how could it fetch a result object for each query. So I'll use the mysqli->insert_id() as you suggest and perform the main table update outside of the multi_query.

Thanks for your help,

Dave