Fwd: Questions from a Newbie - Resend

Dear Webmaster - Please, a response from a person, not an automated response. Thanks. I sent the question that I list below, both to the general and the database list, and have not received any reply. Could you please look into this matter. Have I done something wrong? Thanks. Ethan Rosenberg +++++++++

Date: Tue, 12 Oct 2010 00:24:20 -0400 To: php-db-digest@lists.php.net From: Ethan Rosenberg <ethros@earthlink.net> Subject: Questions from a Newbie - Resend Dear List - Here are some questions, which I am sure are trivial, but I am a newbie, and cannot find the answers online.... I cannot get the following to work. In my Firefox [Iceweasel] browser, I enter the following URL: [w/the http] localhost/CreateNew.php All I get is a blank browser screen. The code contained in the file CreateNew.php is: /* * Create Database test22 */ <html><body> <?php $cxn = mysqli_connect("$host",$user,$password);

echo    "Create database test22;"
echo    "Create table Names2

(

        RecordNum Int(11) Primary Key Not null default=10000 auto_increment,
        FirstName varchar(10),
        LastName varchar(10),
        Height  decimal(4,1),
        Weight0 decimal(4,1),
        BMI decimal(3,1)
        Date0 date

);" echo" Create table Visit2 (

        Indx Int(7) Primary Key Not null auto_increment,
        Weight decimal(4,1) not null,
        StudyDate date not null,
        RecordNum Int(11)

);"

        $sql= "SHOW DATABASES";

?> </html></body> If I search for test22 or Visit2, nothing is found. I would also like to be able to add data to a table, using PHP, which I can do in MySQL as: load data infile '/home/ethan/Databases/tester21.dat.' replace into table Names fields escaped by '\\' terminated by '\t' lines terminated by '\n' ; Thanks in advance. Ethan ======= Using Debian(sid)