TheDemoSite.co.uk  sample code: ASP and MySQL - PHP and MySQL - phpFormMailer - ASP Contact form 
asp code examples with database connectivity

ASP and MySQL
sample code

  Just examples of ASP code, linking to your MySQL database and JavaScript.
|1. Home |2. The Database |3. Add a User |4. Login |5. Get your db online|

asp code examples with database connectivity

The MySQL database (you will need Windows hosting) used for this example has a simple three field table named members.  The SQL query used to create the table is shown below:

CREATE TABLE members (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
password VARCHAR(12) NOT NULL,
username VARCHAR(12) NOT NULL,
index(password),
index(username))

As can be seen above the "id" is the primary key and is auto incremental.  The "username" and "password" fields are both indexed and must have a value to enter a valid record.  Now add a User to this table.

 

ASP.TheDemoSite.co.uk is a MySQL database and ASP code example site. 
The database and ASP scripts are all hosted on:
Janet approved Registrar for AC.UK and GOV.UK domain names - Seiretto Ltd Copyright .  All rights reserved.
Sample code: ASP and MySQL - PHP and MySQL - phpFormMailer - ASP Contact form