Special subjects
function mysql_photo_query($query) {
global $mysql;
$result = mysql_query($query,$mysql)
or die("
$query : failed - " . mysql_errno() . " : " . mysql_error());
return($result);
}
require('/home/tega/httpdocs/scripts/mysql.php');
mysql_select_db('photo', $mysql) or die ('Could not select database');
$result_keyword = mysql_photo_query( "select keyword,name,nb_ima,type,child from keywords order by name");
while (($array = mysql_fetch_row($result_keyword))) {
list($keyword,$name,$nb_ima,$type,$child) = $array;
if ($type == "page") {
$nb_pages = count(explode("\|",$child));
print "
$name($nb_pages pages)";
}
else {
print "
$name ($nb_ima images)";
}
}
?>
require("$home/components/footer.html"); ?>