Artists: Siamese 5 Tattoo
Intro
The Siamese 5 Tattoo has great tattoo artists working within the ranks. Please have a look at details of our artist below, also check out their gallery by simply clicking on the links, if available below.
include 'db_access.php';
// **** Sort by important artist first. Tu. ****
$important_artist = "Tu";
$result = mysql_query("SELECT * FROM s5t_tat_artist AS t1, s5t_tat_artist_images AS t2 WHERE t1.tat_artist_post = 1 AND t1.tat_artist_index_count = t2.details_tat_artist_index_count AND t1.tat_artist_name = '$important_artist' LIMIT 1");
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
list($orig_width, $orig_height, $type, $attr) = getimagesize("images/artist/$row[tat_artist_filename_big]");
list($orig_width_sm, $orig_height_sm, $type_sm, $attr_sm) = getimagesize("images/artist/$row[tat_artist_filename_small]");
echo"
Artist
$row[tat_artist_desc]
";
$tat_artist_id=$row[tat_artist_index_count];
$sql_numImages = "SELECT tat_index_count FROM s5t_tat AS t1, s5t_tat_images AS t2 WHERE t1.tat_artist = $tat_artist_id AND t1.post = '1' AND t2.tat_images_post = '1' AND t1.tat_index_count = t2.details_tat_index_count";
$numImages = mysql_num_rows(mysql_query($sql_numImages));
if( $numImages != 0 ) {
echo"
View $row[tat_artist_name]'s gallery. ($numImages)
"; }
echo"
";
}
mysql_free_result($result);
// END **** Sort by important artist first. Tu. ****
// **** Sort by All ****
$result = mysql_query("SELECT * FROM s5t_tat_artist AS t1, s5t_tat_artist_images AS t2 WHERE t1.tat_artist_name != 'Tu' AND t1.tat_artist_post = 1 AND t1.tat_artist_index_count = t2.details_tat_artist_index_count GROUP BY t1.tat_artist_index_count ORDER BY t1.tat_artist_name ASC");
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
list($orig_width, $orig_height, $type, $attr) = getimagesize("images/artist/$row[tat_artist_filename_big]");
list($orig_width_sm, $orig_height_sm, $type_sm, $attr_sm) = getimagesize("images/artist/$row[tat_artist_filename_small]");
echo"
Artist
$row[tat_artist_desc]
";
$tat_artist_id=$row[tat_artist_index_count];
$sql_numImages = "SELECT tat_index_count FROM s5t_tat AS t1, s5t_tat_images AS t2 WHERE t1.tat_artist = $tat_artist_id AND t1.post = '1' AND t2.tat_images_post = '1' AND t1.tat_index_count = t2.details_tat_index_count";
$numImages = mysql_num_rows(mysql_query($sql_numImages));
if( $numImages != 0 ) {
echo"
View $row[tat_artist_name]'s gallery. ($numImages)
"; }
echo"
";
}
mysql_free_result($result);
// END **** Sort by All ****
?>