Problem in Creating and Inserting Values

[BandanaChaudhury]

I am creating a Table, but I am unable to find the error, that why it is not create, Please help me,
Here's the code

<?php

$servername = "localhost";
$username = "root";
$password = "";
$connect = mysql_connect($servername, $username, $password) or die(mysql_error());

// Create table
mysql_select_db("bctravels", $connect);
$create_table = "CREATE TABLE m_seats
(
sno int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(sno),
room_category varchar(50),
twin int(5),
double int(5),
total int(5),
pass_cap int(5)
)";

//execute query
mysql_query($create_table, $connect);

// Inserting values into table
mysql_query ("INSERT INTO m_seats (room_category, twin, double, total, pass_cap)
VALUES
('Delux Cabin', 15, 5, 20, 40),
('Junior Suite', 12, 6, 18, 36),
('Suite', 0, 4, 4, ,
('Presidential Suite (has a double and a twin room)', 0, 0, 1, 4)");

[php9]

Check the return value of mysql_error(), it will tell if the description of the problem (if it's a problem with your query or database connection).