Recent content by Melvin B

Hello, I was wondering when creating a PHP page that will execute queries. What are the BEST ways to write the queries and open/close connection that way the queries executes fast and doesn't cause to many locked/sleep queries in the mysql SHOW PROCESS LIST.

Hi, I can't seem to locate a mysql select/update query to do the following example. User 1 submits the form and his SPOT# is 23 User 2 submits the form and his SPOT# is 24 User 3 and a User 4 submits the form at the same time giving both Users SPOT# 25. How can I do a select/update query which...