Database connections

<?php
$connect = mysql_connect("localhost", "myDB", "username", "password")
or die("Connection not established");

//creates database
$create = mysql_query("CREATE DATABASE IF NOT EXISTS storage")
or die(mysql_error());

//recently created DB is active
mysql_select_db("storage");

//create table
$table1 = "CREATE TABLE table1 (
id int(10) NOT NULL auto_increment,
file varchar(250) NOT NULL,
)";

$results = mysql_query($storage)
or die (mysql_error());

echo "Database created";
?>

<?php
$connect = mysql_connect("localhost", "myDB", "username", "password")
or die("Connection not established");

mysql_select_db("storage");

$query = "SELECT id, file " .
"FROM table1 ".
"ORDER BY id";

$results = mysql_query($query)
or die(mysql_error());

while ($row = mysql_fetch_array($results)) {
extract($row);
echo $id;
echo "<br />";
echo $file;
}
?>

Thanks for any help.

<?php
$host = "localhost";
$database = "storage";
$uid = "root";
$pwd = "mypass";
$db = new DBAPI($host,$database, $uid,$pwd)
or die ("no connection");
$ds = $db->select('*','table1')
or die("table not found");
echo $ds;
?>

while( $row = $modx->fetchRow( $ds ) ) {

print_r($row);

}