0)) { $cat = $_GET['cat']; $query = "SELECT category_title FROM gallery_cat WHERE category_id='$cat'"; $result = mysql_query($query) or die(mysql_error()); // Check category id exists by seeing if a row returned in query if (mysql_num_rows($result) > 0) { $row = mysql_fetch_array($result, MYSQL_ASSOC); $category_title = $row['category_title']; $category_id = $cat; } } // prepare SQL to get total records if ($category_id > 0) { $getTotal = "SELECT COUNT(*) FROM gallery WHERE category_id='$category_id' and status = 'on'"; } else { $getTotal = "SELECT COUNT(*) FROM gallery WHERE status = 'on'"; } // submit query and store result as $totalPix $total = mysql_query($getTotal); $row = mysql_fetch_row($total); $totalPix = $row[0]; // set the current page $curPage = isset($_GET['curPage']) ? $_GET['curPage'] : 0; // calculate the start row of the subset $startRow = $curPage * GALLERY_SHOWMAX; // prepare SQL to retrieve subset of image details if ($category_id > 0) { $sql = "SELECT * FROM gallery WHERE category_id='$category_id' and status = 'on' ORDER BY display_order LIMIT $startRow,". GALLERY_SHOWMAX; } else { $sql = "SELECT * FROM gallery WHERE status = 'on' ORDER BY display_order LIMIT $startRow,". GALLERY_SHOWMAX; } $result = mysql_query($sql) or die(mysql_error()); // extract the first record as an array $row = mysql_fetch_assoc($result); // get the name for the main image if (isset($_GET['image'])) { $mainImage = $_GET['image']; } else { $mainImage = $row['image']; } // get the dimensions of the main image $imageSize = getimagesize(DIR_FS_SITE_IMAGES . "/gallery/$mainImage"); $image_url = DIR_WS_SITE_IMAGES . "/gallery/$mainImage"; ?> Face Painter Huddersfield, Face Painting West Yorkshire

Face Painting Gallery

Displaying
' . $row['caption'] . '' . "\n"; $row = mysql_fetch_assoc($result); // increment counter after next row extracted $pos++; // if at end of row and records remain, insert tags if ($pos%GALLERY_COLS === 0 && is_array($row)) { echo ' ' . "\n"; echo ' ' . "\n"; } } while($row); // end of loop // new loop to fill in final row while ($pos%GALLERY_COLS) { echo ' ' . "\n"; $pos++; } ?>
 
'; // create a back link if current page greater than 0 if ($curPage > 0) { echo '< Prev'; } else { // otherwise leave the cell empty echo ' '; } echo '' . "\n"; echo ' ' . "\n"; ?>
'; // create a forwards link if more records exist if (($startRow + GALLERY_SHOWMAX) < $totalPix) { echo 'Next >'; } else { // otherwise leave the cell empty echo ' '; } echo '
<?php echo $image_alt; ?>>

Filter gallery by category:

For all events including:

Kids Parties · Birthdays
Christenings · Weddings
Promotional & Corporate
Hen Parties & Nights Out
School & Community
Christmas Parties
Fetes & Galas
Any Social Event

Book Now: Phone Jude to discuss your requirements on:
01484 605791 or
07931 440058
email: jude@artifaces.co.uk

Hundreds of satisfied customers:
'Jude, Thanks a million for your face/back of head/arm painting for our daughters christening last week. It was brilliant, you really made the
day so special for the children. I will highly recommend you to anyone.
Thanks again
Love'
Gary, Karen and Eleanor
Click here to view more testimonials.

We cover a wide area:
Huddersfield, Brighouse, Holmfirth, Bradford, Leeds, Wakefield, Castleford, Batley, Dewsbury, Mirfield, Halifax, Hebden Bridge, Barnsley, Doncaster, Sheffield, Rotherham, York, Manchester and many more...