i have a gallery SCript which i saw in tutorial sitepoint.com
everything is working well except that i want to limit users,which means the albums will be opening accoding to user=name
WHERE SHOULD I PUT THE WHERE CLAUSE LIKE THIS user='$user'
in the script below.
query( "SELECT c.category_id,c.category_name,photo_filename,COUNT(photo_id)
FROM gallery_category as c
LEFT JOIN gallery_photos as p ON p.photo_category = c.category_id
GROUP BY c.category_id" );
here is the link of the tutorial,any help will be appreciated.
http://www.sitepoint.com/article/php-gallery-system-minutes/