MySQL и PHP

CREATE DATABASE mydatabase;

DROP DATABASE mydatabase;

DROP TABLE mytable

USE mydatabase;

CREATE TABLE mytable(
    number INT(10),
    postcode CHAR (6),
    name VARCHAR(30),
    surname VARCHAR(50),
    cash DEC(4,2)
);

INSERT INTO mytable (number, name, surname, cash) VALUES (1, 'Dmitry', 'Ovsyannikov', 5000.00);

SELECT * FROM mytable WHERE number = 1;

SELECT name FROM mytable WHERE cash = 5000.00;

DELETE FROM table WHERE id=1;

$db = mysqli_connect(host, user, password, table) or die('Error');

mysqli_select_db($db);

$query = "INSERT INTO mytable (number) VALUES (1)";

$result = mysqli_query($db, $query) or die('Error');

while ($row = mysqli_fetch_array($result) {
    $name = $row['name'];
    $surname = $row['surname'];
    echo($name.' '.$surname);
}

mysqli_close($db);