hi everyone i have problem in my code i'm create datbase and table by write in php code but in my phpmyadmin it insert the database only the table dose noe exit here my code

<?php

$connect = mysql_connect("127.0.0.1","root","");
$db = mysql_select_db("login");

mysql_query("CREATE DATABASE login");

mysql_query("CREATE TABLE users

(
id int,
fullname varchar(30),
username varchar(30),
password vaechar(32)
)");



echo "Data Inserted!";

?> 
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.