This code will create database and then tables.
Code: Select all
<?php
mysql_connect("localhost","root","q48cur3");
mysql_query("create database data");
mysql_query("use data");
mysql_query("create table users(username char(40))");
?>Code: Select all
<?php
mysql_connect("localhost","root","q48cur3");
mysql_query("create database data; use data; create table users(username char(40))");
?>