<?php
    $host = 'localhost';
    $dbname = 'aplewis2_cs242a33';
    $user = 'XXXX';
    $password = 'XXXX';
    $dbconn = mysql_connect($host, $user, $password) or die ('Could not connect to database: ' . mysql_error());
    mysql_select_db($dbname,$dbconn);

    $sql = "CREATE TABLE Persons(
                FirstName varchar(15),
                LastName varchar(15),
                Age int
                )";
    mysql_query($sql);

    $sql = "INERT INTO Persons
                VALUES('alex','lewis',23)";
    mysql_query($sql);


    $sql = "INERT INTO Persons
                VALUES('alex2','lewis2',23)";
    mysql_query($sql);


    $sql = 'select * from Persons';
    $result = mysql_query($sql) or die ('Query Error: ' . mysql_error());

    $count = mysql_num_rows($result);
    $row = mysql_fetch_row($result);

    echo "Num Rows: " . $count;
    echo "<h1>firstRow:</h1>" . $row[0];

    mysql_free_result($result);
    mysql_close($dbconn);
?>