require ("$DOCUMENT_ROOT/include/constants.inc");
/* Connecting, selecting database */
$link = mysql_connect("mysql.bud-smith.com", "bud-sm", "fixing") or die("Could not connect");
mysql_select_db("bud-sm") or die("Could not select database");
/* Performing SQL query */
$query = "select `id`, `name`, `description`, `thumbnailid`, `slideshowid` from `pages` ";
$query .= "where `id` in ( " . WEDDINGS . ", " . SAMPLE_MAGAZINE . ", " . SAMPLE_WEDDING . ", " . WEDDING_SAMPLES . ", " . SAMPLE_COFFEE_TABLE_BOOK . ") ";
$result = mysql_query($query) or die("Query failed:" . $query );
/* Printing results in HTML */
while ($line = mysql_fetch_array($result, MYSQL_BOTH))
{
$page[$line['id']] = $line;
}
$query = "select slideshow.id, slideshow.name, slideshow.description, count(slide.id) as slidecount, min(slide.order) as so ";
$query .= " from slideshow, slide ";
$query .= " where slideshowId = slideshow.id ";
$query .= " and slideshow.id = " . $page[WEDDINGS]['thumbnailid'];
$query .= " group by slideshow.id, slideshow.name, slideshow.description ";
$query .= " order by slideshow.name";
$result = mysql_query($query) or die("Query failed:" . $query );
/* Printing results in HTML */
$thumbnailcount = 5;
$so = 5;
if ($line = mysql_fetch_array($result, MYSQL_BOTH))
{
$thumbnailcount = $line['slidecount'];
$so = $line['so'];
}
/* Free resultset */
mysql_free_result($result);
/* Closing connection */
mysql_close($link);
?>
Bud Smith Photography - Professional Photographers