Here is how to do it from MySQL Database by svetlio mitev on 9/19/07 05:33 AM Message # 8218
<?php
$dbcnx = @mysql_connect("localhost","root","vertrigo");
$dbselect = @mysql_select_db("smokmovies");
if ((!$dbcnx) || (!$dbselect)) { echo "Can't connect to database"; }
// next, query for a list of titles, files and links.
$query = "SELECT * FROM smok_banners_rotation ORDER BY id ASC";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
