Connect to the MySQL database. The following code connects to a database server named "myserver:"mysql_connect('myserver', 'user', 'password') Retrieve a list of tables from the database.

We are developing a VB6 application that uses MySQL as it's database. The tables are InnoDB. ... When a person needs to lock the table, they check to see if there is information in those 2 fields.