MySQL Forums
Forum List  »  Newbie

Re: Are queries queued?
Posted by: Martin Gavin
Date: June 03, 2009 02:37PM

Hi Rick,

Apologies for my very delayed reply but I have been away from a PC for quite a while.

"I'm assuming you have some programming language that will let you get the 3 rows selected and build the IN clause needed." - I am using PHP as the programming language, is there a way to pass the result of the first query directly in to the IN () in the second query using MySQL?

"Surely there is more to the application? Will the user be shown the 3 items and do something with them? Will some of them then be changed back to 'available'?" - WHen the user is shown the 3 items their next step will be either purchase or search again. If they do not purchase the 3 items within a 3 minute window they will be automatically available through a separate script.

Based on the table create in my previous post, can you recommend some fields to build an index on that would be beneficial?

Martin

Options: ReplyQuote


Subject
Written By
Posted
May 15, 2009 05:32AM
May 15, 2009 01:27PM
May 15, 2009 02:50PM
May 16, 2009 07:19PM
May 16, 2009 07:26PM
May 18, 2009 03:38PM
May 18, 2009 03:35PM
May 18, 2009 11:16PM
Re: Are queries queued?
June 03, 2009 02:37PM
June 03, 2009 07:40PM
June 05, 2009 01:35PM
June 05, 2009 08:47PM
June 06, 2009 11:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.